Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a Bar Chart using a single calculated dimension:
round(([Overall Goals Rating] + [Overall VBBs Rating])/2,0.1)
I need to have a different color for the bar that shows a "3,0" result.
Currently I'm using this expression:
=count(DISTINCT{<Period={'01.12.2022'}, RL-={'2A','3','4A','4B','7'}, [Planning period]={'2022/2023'}>}[System ID])
And this definition in Background Color:
=if((round(([Overall Goals Rating] + [Overall VBBs Rating])/2,0.1))=3,rgb(255,217,47))
But the Background Color isn't working. If I move the RGB function to the "false value" (or "then" in the IF function), all the bars change to that color.
What I take from this is that the "... = 3" condition is never being read as TRUE.
How can I make this work? Thanks
Hi, I tested and it works for me.
Check that all fields exists and that the 3.0 bar has data.
If still doesn't works you can upload a sample that demonstrates the issue to check if there is another thing preventing to color the bar.