Forum Discussion
Show 0 for empty cells in table
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...
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.
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
v-luwang-msft
Community Support
Community SupportHi 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