Forum Discussion
Fusilier2
Helper V
Helper VDynamic 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
Fusilier2Helper V
Helper VThanks for your responses, very helpful and I can get it working if I add in a separated table, however the existing slicer is currently used to filter other visuals on the page so I would need a solution that uses the existing slicer.
I can't upload my pbix file due to org data security.
danextian
Super User
Super UserUsing 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
danextian very good
I did not notice that the customer was ok with hiding the not selected items in the slicer in the below table.
Very good solution!
- Fusilier2
Thank you so, much. Seems to be working fine.
