The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I am looking to create a measure that I can use in conditional formatting of the accent bar to change color based on the incident value of the current month and the previous month. It should be a dynamic measure that returns the color red if the current month's count of incident saves is more than the previous month and green if it is less compared to last month.
The measure to calculate incident saves might need modification to show values just for the current month and not the entire date range. At present the measure looks like this:
Hello @NKotak_Leecare ,
you could use the following measure:
formatting =
SWITCH (
TRUE (),
[IncidentSavesInSelectedInterval] > [lastMonth], "#FF0000",
[IncidentSavesInSelectedInterval] < [lastMonth], "#008000"
)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hi @Idrissshatila ,
I tried using this measure but it always returns red to me regardless of the difference. Also, I want to show blue if the last month's count and the current month's count are the same. So I modified the measure as below:
Thanks!
how are you getting [lastMonth]?
You can do:
last Month= CALCULATE([IncidentSavesInSelectedInterval],PARALLELPERIOD([Date],-1,MONTH))
Hi @mlsx4
Thank you! I tried using that measure but it is returning Red regardless of the count values. Do you have any idea why it is doing that and how can I resolve it?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
79 | |
72 | |
48 | |
39 |
User | Count |
---|---|
138 | |
108 | |
69 | |
64 | |
57 |