Forum Discussion

Manav-Shah's avatar
Manav-Shah
Icon for Helper I rankHelper I
2 years ago

Conditional Formatting in Power BI using measures.

I need to implement the same conditional formatting in Power BI using a measure that apper in below excel sheet. I have two data sheets in Excel. 1) Dashboard     2) Data for conditi...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Manav-Shah 

 

try below measure

Measure = 
var a = CALCULATE(SUM('Table (2)'[value]),'Table (2)'[id]=SELECTEDVALUE('Table'[id]))
var b = IF(a=BLANK(),CALCULATE(SUM('Table'[Value]),'Table'[id]=MIN('Table'[id]),ALL('Table'[Attribute])),a)
var c= IF(SUM('Table'[Value])>=b ,"red","#000000")
RETURN
c

 

1. initial data look like below

 

2. transform it to power query and apply unpivot column

3. close and apply


4. crate matrix which look like below

5. apply conditional formatting using above measure