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.

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

mvbonne 

 

i didnt encounter this in the november update. 

 

try updating to the december 2023 release . and check if the bug exists. 

 

https://www.microsoft.com/en-us/download/details.aspx?id=58494

 

 

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠