topic Conditional Color in Bar chart in Developer

Conditional Color in Bar chart

Kavya123 — Mon, 25 Oct 2021 05:30:31 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 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.

Re: Conditional Color in Bar chart

Anonymous — Wed, 27 Oct 2021 07:43:32 GMT

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.

Re: Conditional Color in Bar chart

Kavya123 — Wed, 27 Oct 2021 12:06:40 GMT

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.