Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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~~
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix,
Many thanks for your help. I made it!
Cheers,
Weijuan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |