Most viewed questions in Power BI

+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
154,523 views
0 votes
3 answers

How to replace Blank with "0" in Power BI Visual?

so you are using the raw source ...READ MORE

Dec 15, 2020 in Power BI by Gitika
• 65,910 points
106,006 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

Dec 16, 2020 in Power BI by Roshni
• 10,520 points
77,438 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

Dec 16, 2020 in Power BI by Roshni
• 10,520 points
70,741 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

Dec 16, 2020 in Power BI by Gitika
• 65,910 points
54,191 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Oct 5, 2018 in Power BI by Kalgi
• 52,360 points
37,091 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

Aug 22, 2019 in Power BI by anonymous
• 33,030 points

edited Dec 31, 2021 by Soumya 33,838 views
+1 vote
3 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

Dec 20, 2019 in Power BI by Tony
• 160 points
29,658 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,570 points
28,424 views
0 votes
1 answer

How do I install PowerBI on Ubuntu ?

Hi, @Bhagyashri, Based on my research, currently, it ...READ MORE

Apr 23, 2020 in Power BI by Gitika
• 65,910 points
28,054 views
0 votes
1 answer

How to create action button in Power BI?

Hi Raghav, Follow the below steps: 1. Click on ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,030 points
26,262 views
0 votes
1 answer

Count occurrences in DAX

You can use DAX functions to do ...READ MORE

Mar 9, 2019 in Power BI by Avantika
• 1,520 points
25,794 views
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
25,195 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,910 points
21,897 views
+1 vote
3 answers

Send dashboards and reports as automated emails on power bi

also, check - https://bihelper.tech It is a cloud service ...READ MORE

Oct 14, 2019 in Power BI by Andrew Caulton
20,136 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

Oct 29, 2019 in Power BI by Cherukuri
• 33,030 points
19,339 views
0 votes
1 answer

show data even for no data - power BI

Hi Latha, To show rows with empty data ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
19,051 views
0 votes
1 answer

PowerQuery : How can I reference a cell's value?

You can do so using a named ...READ MORE

Feb 27, 2019 in Power BI by Shubham
• 13,490 points
18,963 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

Feb 3, 2020 in Power BI by Jitesh
18,649 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

May 23, 2019 in Power BI by VNK
18,542 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
18,482 views
0 votes
1 answer

To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

Nov 26, 2018 in Power BI by Upasana
• 8,620 points
15,156 views
0 votes
0 answers

How to Fix error "DataFormat.Error: We couldn't convert to Number"

Hi,  I am getting below error "DataFormat.Error: We couldn't ...READ MORE

Apr 22, 2019 in Power BI by Lavdeep
• 120 points
14,198 views
0 votes
2 answers

Power Bi duplicate rows

As mentioned by @Lina I'll post achieving the ...READ MORE

Oct 3, 2018 in Power BI by Nilesh
• 7,050 points
13,706 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

Sep 24, 2018 in Power BI by Hannah
• 18,570 points
13,525 views
0 votes
1 answer

Create custom tables in power BI

Hi Sindhu, You can create custom tables by clicking ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
13,357 views
0 votes
1 answer

What is the difference between DAX and Power Query?

DAX stands for Data Analysis Expressions. DAX ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,910 points
12,917 views
0 votes
1 answer

How to convert a Integer to Text value in Power BI?

Make sure you have the correct format ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,910 points
12,245 views
0 votes
1 answer

How do I calculate difference between consecutive rows and columns?

There are two ways through which you ...READ MORE

May 21, 2019 in Power BI by Avantika
• 1,520 points
11,693 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
11,393 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
11,371 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

Feb 28, 2019 in Power BI by Upasana
• 8,620 points
10,455 views
0 votes
1 answer

How to open hyperlink in the same tab in power BI

Hey, the discussion on this topic is ...READ MORE

Jul 10, 2019 in Power BI by anonymous
• 33,030 points
10,432 views
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

May 17, 2019 in Power BI by Cherukuri
• 33,030 points
10,365 views
+1 vote
1 answer

Stacked and a independent column chart in power BI

Hi Rahul, Follow the below steps: 1. Create a ...READ MORE

Jun 12, 2019 in Power BI by anonymous
• 33,030 points
9,863 views
0 votes
1 answer

Dax: Sum of values from many columns in a row

Yes, you can. Try to "Unpivot other columns" ...READ MORE

Apr 3, 2019 in Power BI by Upasana
• 8,620 points
9,825 views
0 votes
1 answer

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,910 points
9,770 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

Oct 18, 2018 in Power BI by Annie97
• 2,160 points
9,299 views
0 votes
1 answer

How to make a slicer like buttons?

Follow the below steps: 1. Create slicer of ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,030 points
9,005 views
0 votes
1 answer

What do “Enable Load” and “Include In Report Refresh” mean/do?

"Include In Report Refresh" means query is ...READ MORE

Dec 21, 2020 in Power BI by Gitika
• 65,910 points
8,779 views
0 votes
1 answer

How to pass parameter to my POWERBI embedded report?

You need add a filter url argument. ...READ MORE

Feb 17, 2022 in Power BI by CoolCoder
• 4,400 points
8,688 views
+1 vote
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

Jul 11, 2019 in Power BI by sindhu
8,630 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

Dec 12, 2018 in Power BI by Upasana
• 8,620 points
8,385 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
8,201 views
+1 vote
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

Sep 19, 2018 in Power BI by Nilesh
• 7,050 points
7,937 views
0 votes
1 answer

How can I get a column value from previous row in Power Query?

Hi Sindhu, add this line as your ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
7,720 views
0 votes
1 answer

Using Multiple filters in DAX

CALCULATE is defined as CALCULATE(<expression>,<filter1>,<filter2>…) This means that you can ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,910 points
7,689 views
0 votes
2 answers

How to format negative numbers in red parenthesis in Power BI Desktop?

Hi Phalguni,  Thanks for your question. It used ...READ MORE

Jun 11, 2020 in Power BI by Excel
• 140 points
7,469 views
0 votes
1 answer

Create a sample visual in power BI using Python script

Follow the below steps: 1. Run Power BI ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,030 points
7,241 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
7,194 views