Conditional field value does not work

[mvbonne]

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?

[Anonymous]

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 Chang

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

[mvbonne]

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.

[Anonymous]

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 Chang

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

[mvbonne]

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 · Accepted solution]

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]

@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! 🤠