How to show data of 0%

[Weijuan]

Wannta to show 0% in chart, Power Bi doesn't show data of 0%.

 The chart didn't show data of wk23 and wk25 due to their data of 0%, just wannta to know how to show them in chart.

Thanks~~

[MFelix · Accepted solution]

Hi @Weijuan,

The question is not the 0% values is the blank values, when you have blank or null values the graphs and visuals by default don't consider those information, what you need to do is in your Query editor change the values from null/blank to 0 or if it's a calculated measure/column do a IF statement validating if result is null and the placing the 0%.

Check the two values images below:

Regards,

MFelix

[Weijuan]

Hi MFelix,

Many thanks for your help. I made it!

Cheers,

Weijuan