Show 0 for empty cells in table

[Anonymous]

I am wondering if there is something similar to excel/pivot table"For empty cells show" (see picture below) in Power BI table/matrix visuals?

I know that is it possible to solve using DAX (replacing empty with 0 in the measure calculation) but I have a lot of measures that would need to be changed in that case

[Greg_Deckler · Accepted solution]

@Anonymous No, you would have to solve that in DAX. There is a "Show values with no data" but that just shows blanks if that is what the measure returns.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Adjust the corresponding measures, which have null values that you want to transform to 0：

newmeasure= var beforemeasure=（here is the measure you used before)
return if(beforemeasure=blank(),0,beforemeasure)

Wish it is helpful for you!

Best Regards

Lucien

[Greg_Deckler · Accepted solution]

@Anonymous No, you would have to solve that in DAX. There is a "Show values with no data" but that just shows blanks if that is what the measure returns.

[Syndicate_Admin]

Could use mwhite space

Then create a measure with the function

SELECTEDVALUE, this function returns the value if the columnName context has been filtered to a single different value. Otherwise, it returns alternateResult. (in this case we will assign a 0 to the alternative value)