Forum Discussion
Manav-Shah
Helper I
Helper IConditional 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...
talespin
Solution Sage
Solution SageHi Manav-Shah ,
You create a measure and set Formatting > cell > font
Measure =
//This is your Matrix/Dashboard
VAR _Val = SELECTEDVALUE(Table[Research Problem])
//This is for Total table, replace table/column names/Filter value
VAR _Val2 = CALCULATE( VALUES(Table[Total]), Table[Problem] = _Val )
RETURN IF( _Val > _Val2, "Red")
Manav-ShahHelper I
Helper II do not want conditional formatting using max value.
I need Conditional formatting from below image in Power BI.
- talespin
hi Manav-Shah ,
It is not takeing MAX value, it is taking MAX of single value, I changed it to VALUES.
Measure =//This variable fetches the current value of Research problem in current cell of your Matrix/DashboardVAR _Val = SELECTEDVALUE(Table[Research Problem])//This is for Total table, it searches your total table for Problem text it retrieved into above variable .Replace table/column names/Filter value. Since there is only one value for one problem, MAX or VALUES doesn't make any difference.VAR _Val2 = CALCULATE( VALUES(Table[Total]), Table[Problem] = _Val )RETURN IF( _Val > _Val2, "Red")- Manav-Shah
Hi talespin,
It shows error.
Can you do conditional formatting using formula that I have written in last image?
- talespin