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" )

     

  • Kavya123's avatar
    Kavya123
    Icon for Helper III rankHelper III
    7 years ago

    Hi  Zubair Muhammad,

     

    Thanks for ther reply. It is working for single text value. For company B there are two texts. If i select company B (Direct assistance,Management testing) both bars should highlight.

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

      Kavya123

       

      Try modifying the measure as

       

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

       

      • Kavya123's avatar
        Kavya123
        Icon for Helper III rankHelper III
        7 years ago

        Thanks a lot  it worked.