Forum Discussion
Conditional formatting on calculated item in calculation group
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
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.
5 Replies
- MZZFrequent Visitor
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
Super User
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.
- MZZFrequent Visitor
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.
- MZZFrequent Visitor
ah, and here is the model:
- v-kpoloju-msft
Community Support
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