Forum Discussion
Fusilier2
Helper V
1 year agoDynamic 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. ...
- 1 year ago
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
FBergamaschi
Super User
1 year agowith your existig slicer it is impossible to obtain what you are asking as that will filter automatically the value you select
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Fusilier2
Helper V
1 year agoAh, OK. Thanks for responding.
- FBergamaschi1 year ago
Super User
You are welcome, pls mark as a solution and kudos if you believe anybody deserves it
so others can easily find the answers and possible solutions
Thx