Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
I've tried several combinations but I can't get the conditional formatting right.
I have a card in my report that has the measure to compute for the % variance of the volume from previous month. I'm using the measure 'VolumeDiffvsPM' in my card.
VolumeDiffvsPM = ([Volume]/[Volume_PM])-1
Volume = SUM('CR tbl_phrawsales'[Actually billed amount])
Volume_PM = CALCULATE([Volume],DATEADD('Calendar'[Date],-1,MONTH))
Simply put, I want the % values to be green if volume increased and red if it decreased. This is my current set-up and I can't produce the output of conditional formatting that I want.
Hope you can help me!
Solved! Go to Solution.
@newgirl , You have shown measure as VolumeDiffvsPM , but you are using VolumeDiffvsPY in conditional formatting
@newgirl , You have shown measure as VolumeDiffvsPM , but you are using VolumeDiffvsPY in conditional formatting
Ooh so that's why! It's weird because I didn't change the dropdown in 'Based on Field' but after checking my file when I saw your reply, it looks like when I use the format painter, it also copies the choice from the 'Based on Field' from the previous card.
Nevertheless, thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |