Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm putting together a dashboard that has two bar charts, they each display different measures for the same items.
Item A, Item 2 and Item 3.
Some days I refresh the data and whichever Item has a value of zero disappears from the X axis.
What I want is for the bar chart to always show the same values in the x-axis in the same order, even if sometimes some of them are zero and display no bar.
Is that possible?
Thanks!
Solved! Go to Solution.
In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.
In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.
Thanks that did it.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |