Forum Discussion
Conditional Colouring Bar Chart
- 1 year ago
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.
- 1 year ago
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 SuryaDave,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.
Thank you.
Hi, no it has not resolved yet ..
Ashish_Mathur requested for more information that I shared yesterday ....so I waiting for his response & hopefully with his expertise I might get suggestion that can help in resolving my query / question ....