Forum Discussion
Solved
Dynamic bar color
Hope somebody can help with this? I have a slicer and a clustered bar chart. The slicer shows a list of departments and the bar chart shows the results for each department of a survey question. ...
Using the same disconnected table but with the logic in the measure reversed
Disconnected Total Revenue = CALCULATE ( [Total Revenue], TREATAS ( VALUES ( 'Disconnected Category'[Category] ), Category[Category] ) ) Disconnected Conditional Bar Color = IF ( SELECTEDVALUE ( 'Disconnected Category'[Category] ) IN VALUES ( Category[Category] ) && ISFILTERED ( Category ), "red" )Please see the attached pbix
Have you even validated your response before posting it?
Why are you telling OP to create a field parameter table by adding all the deparment fields. It is clear in the screenshots that the departments are in a single column? And even if you meant measures by fields, why would you have OP to unnecessarily create one for each distinct department? And what's with those extra responses?
Hello danextian,
The response you commented on has been removed for being inaccurate.
Best,
Natalie H.
Community Manager