Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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's avatar
    v-luwang-msft
    5 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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)