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 using a categorical x-axis for a simple column chart. In this case, it's important for me to always show all categories - to show those categories with blank (or 0 value). The problem is that the categories without any values are hidden by default and there seems to be no easy way to prevent it from happening.
Is there a good solution for this?
Solved! Go to Solution.
A workaround I just found was to create a Measure that returns 0 if blank for the value, like this:
IF(ISBLANK(value); 0; value)
However, the same method does not seem to work for regular/calculated columns.
Please let me know if there are other ways though.
Unable to find that option in my report .
Can you share a screenshot where that option is visible?
I am unable to find that option in my report.
Can you please share with me the screenshot where that option is visible?
I am unable to find that option in my report.
Can you please share with me the screenshot where the option is available?
On the visualisations pane, once a field is dropped into the axis section there is a small downwards arrow. Click this and the option is near the bottom of that list.
You are the best 🙂
Ah, I had totally missed that option. Exactly what I was looking for, thank you!
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |