Conditional Color in Bar chart

[Kavya123]

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 chart=

VAR _SELECTCompanyID =
CALCULATE( SELECTEDVALUE(Company_DataIsland[POrgID] ), REMOVEFILTERS(Company_Info[Sector] ))-- same as REMOVEFILTERS ( 'Product'[Color] )

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 values in the bar should change.  Color condition is based on company selection. company name and  sector  fields are not linked.

Please let me know.

[Kavya123]

Hi,

Thanks for the response. Please find the attached screenshots.

Below is the conditional color measure we are using. If we select the filter sector the color should not change. It should be "#dc6900".

In second screenshot after selecting sector field color is changing to "#FFB500" but it should be #dc6900. (Only company filter selection is required)

Color Measure =

VAR _SELECTCompanyID =
CALCULATE( SELECTEDVALUE(Company_DataIsland[POrgID] ), all(Sector[Sector] ))-- same as REMOVEFILTERS ( 'Product'[Color] )

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

Note: Company_DataIsland[POrgID] ) and Sector[Sector]  filelds are coming from different table both are not linked. 
AnswerHistory_Benchmarking and sector tables are linked.

[Anonymous]

Hi @Kavya123 

Your data model is complex, I need to know more details about your data model. Please share a sample with us and show me the result you want by screenshot. This will make it easier for us to solve your problem.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.