Problem of Filter showing -100% for Stacked Bar Chart

[PeraZo]

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.

[selimovd]

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%).

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd · Accepted 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.

If you need any help please let me know.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[PeraZo]

Hi,

Thank you for solution. It's nicely working.

Thank you and apologize for late reply.

Pera Zo