Forum Discussion

Fusilier2's avatar
Fusilier2
Icon for Helper V rankHelper V
1 year ago
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. ...
Need Help
  • danextian's avatar
    danextian
    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

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Fusilier2 

You’ll want to use a disconnected table for the categories. If you use the same table (or one that's related), selecting something like "Finance & Services" will filter the bar chart to just that one category. With a disconnected table, you avoid that and can still apply conditional formatting using a measure that refers to it.

 

Please see the attached sample pbix.