Conditional formatting on calculated item in calculation group

[MZZ]

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 

[MZZ]

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....

[Irwan · Accepted solution]

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.

[MZZ]

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.

[MZZ]

ah, and here is the model:

[v-kpoloju-msft]

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