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,010 points
93,026 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,850 points
54,326 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,500 points
45,265 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,500 points
36,584 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
34,144 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,850 points
30,497 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
21,188 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,010 points
19,844 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
18,713 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,850 points
17,501 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
17,283 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,010 points
16,455 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
15,835 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,010 points

edited Dec 31, 2021 by Soumya 15,418 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,010 points
15,181 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
15,134 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
13,759 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
13,417 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
12,306 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
12,238 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,850 points
12,152 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,040 points
11,721 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
11,637 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
10,225 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,010 points
9,966 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,010 points
9,386 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,010 points
8,770 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,010 points
8,290 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
7,785 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,010 points
7,613 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,850 points
7,410 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,010 points
7,255 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
6,912 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
6,879 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,040 points
6,210 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,010 points
6,044 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,010 points
6,006 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

Oct 22, 2018 in Power BI by Hannah
• 18,570 points
5,911 views
0 votes
1 answer

How to add image in Power BI Report?

Follow the below steps: Create a column with ...READ MORE

Oct 31, 2019 in Power BI by Cherukuri
• 33,010 points
5,876 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,010 points
5,836 views
0 votes
1 answer

Calculating MoM Variance of a Measure Field using DAX

Create an intermediate calculated column that considers ...READ MORE

Feb 28, 2019 in Power BI by Shubham
• 13,490 points
5,711 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 5,592 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
5,506 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,010 points
5,425 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
5,269 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

Dec 14, 2018 in Power BI by Upasana
• 8,620 points
5,171 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,850 points
5,037 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,010 points
4,808 views
0 votes
1 answer

How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

Jul 28, 2020 in Power BI by Gitika
• 65,850 points
4,624 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
4,574 views