cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hayoung
Helper IV
Helper IV

Show 0% row if it is 0%

I make below visuals by table visual. However, I found that it will disappear the row if it is 0%. How could i also show 0% even it is 0%?wqwqw.PNG

2 REPLIES 2
amitchandak
Super User
Super User

@Hayoung , add 0 to your meausre

 

percent measure = [% Measure]+0

i am using calculate(count()) as my measure and then change it into percent of grand total. It seems not work.

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.