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 have a chart where I show data labels (see picture).
In case of a 0 value, I would like to hide the label. Is this possible?
Note that I do not necessarily want to filter 0 values. These values should still stay in the chart, just without a label.
Hi @janfcarl ,
You could try below measure to see whether it work or not. If this doesn't work, please inform me your simple sample.
Measure = if( SUM('Table'[amount])/SUM('Table'[amount2])=0, BLANK(),SUM('Table'[amount])/SUM('Table'[amount2]))
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zoe,
as soon as I check "Show items with no data" option an x axis, it works as expected. Thank you!
Jan
Hi Zoe,
thanks for your reply, I tried the solution.
The problem is the entries vanish from the x axis if the values are 0.
E.g. if I have 3 entries, a = 0, b = 3, c = 5 and I use the condition, only b and c are shown on the x axis.
Is it possible to not filter the entries and still show a, b, c?
Kind regards,
Jan
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |