Forum Discussion

sriramk's avatar
sriramk
Icon for Helper I rankHelper I
3 years ago

Column specific color scaling in Matrix table

Hi Experts! I am trying to colour scale based on values. When I apply conditional formatting, it is applying on the whole of the values in the Matrix table. Looking for a solution which applies colo...
Conditional Formatting column
Desktop
Need Help DAX measure
Report
sriramk's avatar
sriramk
Icon for Helper I rankHelper I
3 years ago

Thank you. I tried this but somehow I am missing.

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Could you please explain the issue or share the PBIX file after removing sensitive data?

    • sriramk's avatar
      sriramk
      Icon for Helper I rankHelper I
      3 years ago

      Hi, My desired result should be colour scaled on percentage of "column total (%CT) of Average of Yield Capacity"(instead of only "Yield Capacity").


      For example: "Prod18" & "Prod39" are also performing good with their own capacity similar to other Prod's but colour scale shows complete red color. 

       

      PBIX file is available at https://drive.google.com/file/d/1BMTfEw485QsAdUvMM9Y5mqhQQ1gIt_0Y/view?usp=sharing . 

       

      Thanks for your solution in advance!