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.
Hi I am using "Stacked Bar Chart" and "Table" in a report.
Whenever I filter a particular row in the "table", the stacked bar dynamically changes to the selected filter on the table, but shows -100%, which is looking a little ugly.
Does anyone know 1.how not to dynamically change the filter, 2.Hide the value with "highlighted -100%"?
I tried for the possible solutions but coud not reach one.
Thank you very much.
Solved! Go to Solution.
Hey @PeraZo ,
did it work with the approach I suggested?
I'm curious if you could solve this issue 🙂
If yes, then I would be happy if you could mark my post as solution. This helps the next person who is stumbling across this topic to see immediately what approach worked, without testing it for themselves.
Hey @PeraZo ,
you can handle that in the measure.
For example you could say:
my corrected Measure =
IF( [myMeasure] = -1, BLANK(), [myMeasure] )
As blank values are not shown it would be empty if the value euqals -1 (=-100%).
Hey @PeraZo ,
did it work with the approach I suggested?
I'm curious if you could solve this issue 🙂
If yes, then I would be happy if you could mark my post as solution. This helps the next person who is stumbling across this topic to see immediately what approach worked, without testing it for themselves.
Hi,
Thank you for solution. It's nicely working.
Thank you and apologize for late reply.
Pera Zo
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 |