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.
I'm missing something simple I'm sure, but I have a table of % values and a bar chart visual of the same. Both are suppressing 0 values, but I can;t enable the option to display 0's. I'm expecting a dropdown in teh top right corner of each to set options, ubt it doesn;t appear. What am I doing wrong/missing?
Solved! Go to Solution.
Hi @shill1000,
Please switch the summary mode of value field to 'do not summarize' to show zero values.
In addition, above method only works on table visual. When you use bar chart, value field shows as summarized value.(if current column which in value field can't be summarized, it will show the the value as count of xxxxx)
BTW, current power bi not contains features to force display zero value.
Regards,
Xiaoxin Sheng
Hi @shill1000,
Please switch the summary mode of value field to 'do not summarize' to show zero values.
In addition, above method only works on table visual. When you use bar chart, value field shows as summarized value.(if current column which in value field can't be summarized, it will show the the value as count of xxxxx)
BTW, current power bi not contains features to force display zero value.
Regards,
Xiaoxin Sheng
Xiaxin,
Thanks, that wasn;t the actual solution but it pointed me in teh right direction. I was looking at the value summary options, and once I checked the Axis oprtions I found the show items with no data option. Doh!
Simon
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |