topic Re: Conditional formatting on calculated item in calculation group in DAX Commands and Tips

Conditional formatting on calculated item in calculation group

MZZ — Fri, 06 Mar 2026 08:20:11 GMT

Hello!

I've this issue - been following video on how to apply format in calculation item which is "vs prev month". https://www.youtube.com/watch?v=ToAlPA5KvUc

But from some reason it does not work, my setup:

calculation group:

Then I created a measure as per vid:

and applied this in conditional formatting icons :

as you can see on table, vs prev month values are slightly moved to the left, as if icon is there, but it's not showing anything, conditional formatting setup:

any ideas why it doesnt work? I digged through all available resources on the internet

Re: Conditional formatting on calculated item in calculation group

MZZ — Fri, 06 Mar 2026 08:21:19 GMT

ah, and here is the model:

Re: Conditional formatting on calculated item in calculation group

v-kpoloju-msft — Sun, 08 Mar 2026 11:03:26 GMT

Hi @MZZ,

Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum

Re: Conditional formatting on calculated item in calculation group

MZZ — Mon, 09 Mar 2026 06:47:13 GMT

Hello!

This is not something I asked for, please read my thread carefully 🙂

It should be combined with calculation groups + proper formatting for division (which should be %).

The pbix you did is basic scenario, where everything works. But when you try it in calculation group from some reason formatting does not work....

Re: Conditional formatting on calculated item in calculation group

Irwan — Tue, 10 Mar 2026 03:06:51 GMT

maybe try checking this thread and see if the expert can help you @parry2k .

Calculation Groups and Conditional Formatting can ... - Microsoft Fabric Community

Solved: Conditional Formatting using Calculation Groups no... - Microsoft Fabric Community

Thank you.

Re: Conditional formatting on calculated item in calculation group

MZZ — Tue, 10 Mar 2026 07:40:46 GMT

Thanks for that link.

Actually....the issue was that in my calculation item responsible for division I used code where I referred to other calculation items, sth like:

so formatting didn't work...when I removed calculate() and pasted the actual code from calculation items formatting worked

I think it's a bit...unintuitive to be honest, but I'm glad I solved that error.