Forum Discussion

mvbonne's avatar
mvbonne
New Member
2 years ago
Solved

Conditional field value does not work

Hi   After the lastest update of Power BI in november, i can no longer chose any column which i want to format my measure on. It shows red right from the begining even tho i havent chosen anything...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mvbonne ,

     

    Also, still controlled by measure, you can check the following:

    StatusColor = var _t = ADDCOLUMNS('Table',"rank",RANKX(FILTER(ALL('Table'),[Desc]=1),[Value],,DESC,Skip))
RETURN MAXX(_t,[rank])

Measure = IF(MAX('Table'[Desc]) = 1,SWITCH([StatusColor],1,"blue",2,"red",3,"yellow"))

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

mvbonne's avatar
mvbonne
New Member
2 years ago

Yes that i am aware of.

I try to chose a conditional formating on a column which is in the same tabel.

For example i want to have a different background color for the cash flow header here and there is another column what is 1 for these name which i what to format.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mvbonne ,

 

Also, still controlled by measure, you can check the following:

StatusColor = var _t = ADDCOLUMNS('Table',"rank",RANKX(FILTER(ALL('Table'),[Desc]=1),[Value],,DESC,Skip))
RETURN MAXX(_t,[rank])

Measure = IF(MAX('Table'[Desc]) = 1,SWITCH([StatusColor],1,"blue",2,"red",3,"yellow"))

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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