Color condition in Bar chart

Kavya123 — Sat, 23 Oct 2021 16:31:02 GMT

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 =
CALCULATE(DISTINCTCOUNT( AnswerHistory_Benchmarking[POrganization]) , FILTER(AnswerHistory_Benchmarking, AnswerHistory_Benchmarking[POrganization] <> 6377
)
, FILTER(RR_Datapoint,RR_Datapoint[RR_ID]=1) )
If I select filter Sector values are changing accordingly.

And this is the conditional Color Measure we are using in bar cahrt =

VAR _SELECTCompanyID =
CALCULATE( SELECTEDVALUE(Company_DataIsland[POrgID] ))
VAR _VALUES= VALUES(AnswerHistory_Benchmarking[POrganization] )
RETURN
IF ( _SELECTCompanyID IN _VALUES ,"#dc6900","#FFB500 ")

Now If I select Sector filter bar colors should not change only measure value should change. Color should reflect only based on company selection. Please let me know.

Re: Color condition in Bar chart

Anonymous — Tue, 26 Oct 2021 01:01:41 GMT

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

topic Color condition in Bar chart in Developer

Color condition in Bar chart

Re: Color condition in Bar chart