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
3,291 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
• 29,170 points

Hi Gitika,

I'm trying same way to replace blanks in Matrix but this way is not working. Could you (or anyone who can) please help if have another solution for this

I'm writing DAX as below:

Distinct IDs=

var dist_id = DISTINCTCOUNT('Table'[ID)

return

IF(ISBLANK(dist_id),"0",dist_id)

Some of the blanks are getting replaced however, some are still there.

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,460 points
22,542 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,590 points
111 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,590 points
97 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
364 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,850 points
87 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,850 points
112 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,850 points
112 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
• 29,170 points
320 views
0 votes
1 answer