Forum Discussion
Kavya123
Helper III
Helper IIIDynamically 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" )
Zubair_Muhammad
Community Champion
Community Champion
Try modifying the measure as
Measure 2 = IF ( VALUES ( Table2[Text value] ) IN VALUES ( Table1[Text ] ), "#6c1610" )
Kavya123Helper III
Helper III
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.
- Zubair_Muhammad
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] ) )- Kavya123
Thanks a lot for the solution.