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
159,983 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,770 points
108,864 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,480 points
79,015 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,480 points
73,641 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,770 points
56,024 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,350 points
37,664 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 37,057 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
30,710 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,520 points
30,171 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,770 points
29,986 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
27,166 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
26,446 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,854 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,770 points
22,675 views
+1 vote
3 answers

Send dashboards and reports as automated emails on power bi

It is a cloud service for sending ...READ MORE

Oct 14, 2019 in Power BI by Andrew Caulton
21,166 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
20,187 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,595 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
19,555 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
19,225 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
19,039 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,954 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,623 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,678 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
14,493 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,060 points
14,043 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,520 points
14,021 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,770 points
13,456 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,770 points
12,875 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,770 points
12,133 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
12,010 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,969 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
11,337 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,974 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,687 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,770 points
10,654 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
10,499 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
10,323 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
9,958 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,626 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,770 points
9,488 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,402 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,420 points
9,220 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,818 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,802 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,060 points
8,342 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,770 points
8,276 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
8,240 views
0 votes
2 answers

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

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

Jun 11, 2020 in Power BI by Excel
• 140 points
7,886 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,674 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

Nov 27, 2018 in Power BI by Shubham
• 13,490 points
7,585 views