Forum Discussion

arun2001mjl's avatar
arun2001mjl
Helper II
3 years ago
Solved

Conditional Formatting with Multiple Columns with Multiple Files in PowerBI

Hello Team,   I have combined 5 files in powerbi with same columns but values are different. In PowerBI, We have created a Matrix and shown "Server" as rows, "file name" as column and "Snapshot Us...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi arun2001mjl ,

     

    Based on your description, I have created a simple sample:

    First add a new column:

    Then use this measure to conditional formmating your data:

    Measure = 
var _a = CALCULATE(SELECTEDVALUE('Table'[Snapshot Usage]),FILTER(ALL('Table'),[Cluster]=SELECTEDVALUE('Table'[Cluster])&&[Server]=SELECTEDVALUE('Table'[Server])&&[Sort]=SELECTEDVALUE('Table'[Sort])-1))
return IF(_a=SELECTEDVALUE('Table'[Snapshot Usage]),"Red","White")

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

arun2001mjl's avatar
arun2001mjl
Helper II
3 years ago

Excellent. It works fine. Thank you very much Jianbo Li