Conditional Formatting with Multiple Columns with Multiple Files in PowerBI

[arun2001mjl]

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 Usage" as Value. 

We have 5 files in a folder like below table.. Cluster Name and Server Name will be same in all 5 files but Snapshot Usage value alone will differ.

Daily file will be uploaded to this folder with file name as Date.

Cluster	Server	Snapshot Usage
Cluster1	Server1	162.53 GiB
Cluster1	Server2	-
Cluster1	Server3	0.00 B
Cluster1	Server4	43.09 GiB
Cluster1	Server5	318.91 GiB
Cluster1	Server6	-
Cluster1	Server7	0.00 B

Now we need conditional formatting in below matrix table.. Is it possible to highlight a cell with different colour if left side value is same?

Could you please suggest.

I dont have any date columns in any of the files only file name will have date.

Regards

Arun

[arun2001mjl]

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

[v-jianboli-msft · Accepted solution]

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.