Forum Discussion

Kavya123's avatar
Kavya123
Helper III
4 years ago
Solved

Color condition in Bar chart

Hi All, I have a field company name from one table. And different field called Sector from different table. This is the measure we are using in bar chart which is linked to Sector field. Measure 4...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Kavya123,

    I think you need to remove the relationship from the slicer source table to the fact table first, then you can directly use measure expression to extract the selection and use in if statement for color formating.

    Color Measure =
VAR selected =
    VALUES ( Company_DataIsland[POrgID] )
VAR _current =
    SELECTEDVALUE ( AnswerHistory_Benchmarking[POrganization] )
RETURN
    IF ( _current IN selected, "#dc6900", "#FFB500 " )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Kavya123,

I think you need to remove the relationship from the slicer source table to the fact table first, then you can directly use measure expression to extract the selection and use in if statement for color formating.

Color Measure =
VAR selected =
    VALUES ( Company_DataIsland[POrgID] )
VAR _current =
    SELECTEDVALUE ( AnswerHistory_Benchmarking[POrganization] )
RETURN
    IF ( _current IN selected, "#dc6900", "#FFB500 " )

Regards,

Xiaoxin Sheng