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" )
Is it possible to format colors both by rules and field value together. The matched text bar should highlight the color based on the rules.
For example if we select gold color, the matched text bar should highlight in red color and remaining bars should be gold colors.
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.