Forum Discussion
Isuue with Conditional Formatting withIin calculation groups
Salut Anonymous
Your thread is very confusing to me as well! the [CoditionalF_Acticity] can only return values into one Column. However I think you want to spread the Return (Switch) result into 8 columns!! Not possible. Then you want to add conditional formating to a measure into only 1 column! the SELECTEDVALUE also, that column how many values that is looking for inside the column!
Why don't apply the Conditional formating of your 8 Calculations on each of them one by one inside your visual?
Trop de confusion Mariem 😉
Can you share a Dummy/Sample of your PIBX file! It can help me better to assist you.
Hello aj1973
Thanks for taking the time to read and answer my post
However, I'm not sure that I quite fully understand your recommendation.
I don't want to apply the conditional formatting to all colomuns, I just need specific ones, and since there is no "direct" use of formatting colomuns with calculation groups ( i'm not using measures but calculations groups), I have tried to use the method indicated in this blog.
https://exceed.hr/blog/conditional-formatting-with-calculation-groups-in-powerbi-matrix-visual/
This method is actually working in one case but not in the other so I tried to tweek it a bit and use SWITCH instead of IF so that the conditional formatting is applied to the specfic colomun and ignored for the rest
I hope the link to the blog will make my request a bit less confusing 🙂
Kind Regards,
Mariem,
Hi Anonymous
Indeed the link helped me to get away from my confusion lol.
I tried to replicate both of your formulas into my Model and it all worked fine
In the window of the
You need to close the condition by another Rule "else". In your Model there are numbers > 400 so by default the switch doesn't return Blank() it returns the default color "Bleu ciel".
I think by adding a rule you can get what you want.
It sounds like you made Power Bi getting confused 😉