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

0 votes

Above in first visual i have taken count of region, however when i select slicer for particular region (e.g L America), others are showing Blank... I want to show value as 0 when it shows blank on visual. Blank is coming because i have selected particular region in slicer .

Feb 6 in Power BI by Sujit
• 120 points
62 views

1 answer to this question.

0 votes

Hi, Sujit

You can do this in two ways:

  • In query-editor (follow the steps below)

1) In your power bi desktop, click on edit queries.

2) Select column right-clicks on it.

3) Choose to replace the value.

4) Enter "null" in find value in "replace value enter "0"

5) Close and apply

*You should see "0" wherever you have nulls in that column.

  • Using​ the new calculated measure​

Create a new measure using the following code ​:

Column = IF(ISBLANK(**original column**),0,**original column**)

**original column** - your name for the column you are using.

Then change the value to the new column and it should work.

answered Feb 7 by Gitika
• 25,830 points

Related Questions In Power BI

+3 votes
1 answer

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

answered Mar 8, 2019 in Power BI by Cherukuri
• 32,440 points
13,267 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,570 points
82 views
0 votes
1 answer

To create link visual in Power BI

You can disable sandboxing by adding this ...READ MORE

answered Nov 21, 2018 in Power BI by Upasana
• 8,570 points
80 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,010 points
216 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,810 points
67 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,810 points
97 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,810 points
84 views
+1 vote
1 answer
0 votes
1 answer

How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE

answered Feb 6 in Power BI by Gitika
• 25,830 points
33 views
0 votes
1 answer