Conditional formatting on the basis of difference between first column and first row

Question

I have been trying to replicate one feature of Excel conditional formatting on Power Bi.

The data set is like, a same set of numbers have been written in both the first row and column represented as column names and row names. I want to fill the cells where the difference between the corresponding row name & column name is equal.

For reference do check the attached screenshot.

Thanks in advance

Sample conditional formatting done on Excel

v-frfei-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
What does your data look like? Could you please share your sample data&nbsp; to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.&nbsp; BTW, As I know we cannot get column name by DAX in power bi currecntly.&nbsp;

anonymous · Answer

Link to the file - https://benoriventures-my.sharepoint.com/:x:/g/personal/abhilash_naik_benoriknowledge_com/EdoUHjbHKSpAsa9_bONlaQgBj_aQtBlBdGGQmhwy6AGy2A?e=47uV8Y

I am trying to apply the conditional formatting as per the difference between the months mentioned in the first column & row.

Thanks in advance

Forum Discussion

Conditional formatting on the basis of difference between first column and first row

2 Replies

Related content

Conditional Formatting

Conditional formatting for difference between bars?

Conditional Formatting using DAX

Condition formatting

Conditional Formatting