Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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!
User | Count |
---|---|
90 | |
73 | |
71 | |
59 | |
53 |
User | Count |
---|---|
42 | |
41 | |
34 | |
32 | |
31 |