Forum Discussion

Kavya123's avatar
Kavya123
Icon for Helper III rankHelper III
7 years ago
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Kavya123

     

    Try modifying the measure as

     

    Measure 2 =
IF ( VALUES ( Table2[Text value] ) IN VALUES ( Table1[Text ] ), "#6c1610" )

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Kavya123

 

you can Define a MEASURE like following and use it for conditional formatting

 

Measure 2 =
IF (
    SELECTEDVALUE ( Table2[Text value] ) = SELECTEDVALUE ( Table1[Text ] ),
    "#6c1610"
)