Forum Discussion
Solved
Dynamically changing colors in Bar chart
Hi Everyone, I have a requirenment to display a different color for bar based on the condition. In the below screenshot the text Internal Audit (3rd line of Defense) is coming from Table 1, a...
Try modifying the measure as
Measure 2 = IF ( VALUES ( Table2[Text value] ) IN VALUES ( Table1[Text ] ), "#6c1610" )
Sorry for late reply.
See if the attached file helps
You can create a small table defining colors and hex codes.
You can get codes from
https://www.w3schools.com/colors/colors_picker.asp
Now you can modify the MEASURE AS
Measure 2 =
IF (
VALUES ( Table2[Text value] ) IN VALUES ( Table1[Text ] ),
MIN ( Colors[HexCode] )
)
Thanks a lot for the solution.