Forum Discussion
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.
Could there be some settings which is disabled or what is wrong?
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
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! 🤠Hi mvbonne ,
You need a color selection measure and you can check the results as follows:
StatusColor = SWITCH(TRUE(),MAX('Table'[Value])>50,"blue",MAX('Table'[Value])<40,"red")An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
What if i also need to change background on the first column (which is in my case is the account name).
Somehow it does not work on a specific dataset, but the function works in others dataset.Hi mvbonne ,
Adding different condition formats for different fields, which also still has some limitations, you can refer to:Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
