Forum Discussion
Conditional Colouring Bar Chart
Hi SuryaDave
You can use disconected table of organization , and keep the visual interactions.+ this tablle will be the source for the slicer :
For the color you can use a DAX with the wanted color HEXA codes ( i used names of colors just to show the logic) :
Color =
if (SELECTEDVALUE(Sheet1[Organisation])= "State Level", "Green",
IF(SELECTEDVALUE(Sheet1[Organisation]) IN( VALUES(Organization[Organisation])),"Pink", "Grey" ))Result :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi SuryaDave
You can use the method of "play role relationship".
Create a inactive relationship without your table and organizations :For other visualizations that need to be filtered you can use the "Userelationship" function to make the relationship active .
Like :Filtered_measure = CALCULATE(AVERAGE(Sheet1[Avg Values]),USERELATIONSHIP(Organization[Organisation],Sheet1[Organisation]))Result:
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Ritaf1983 I had a look at your solution & it is doing exactly what I described as my problem. However, what I realised is, I forgot to mention in my post that in my real world problem scenario - the "organisation" slicers is actually being used to filter other charts.
In the solution that you suggested, "organisation" slicers is being used to dynamically change the colour instead of filtering / slicing organisation.
Do you have any other suggestion / solution that can achieve both ? I mean a slicer that can filter organisation as well as bar chart changing colour based on selected value in that "organisation" slicer ?
Thanks
Hi SuryaDave
You can use the method of "play role relationship".
Create a inactive relationship without your table and organizations :
For other visualizations that need to be filtered you can use the "Userelationship" function to make the relationship active .
Like :
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.