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 I have a query where I am tying to compare and assign RAG status for any 3 months values in a rolling 6 months period. For example If the % is less than 75% then assign RED etc.
Example data:
Date | Value | Target % |
01/10/2023 | 6027 | 50.23% |
01/11/2023 | 8950 | 74.58% |
01/12/2023 | 8500 | 70.83% |
01/01/2024 | 11500 | 95.83% |
01/02/2024 | 4931 | 41.09% |
01/03/2024 | 5629 | 46.91% |
Solved! Go to Solution.
do you mean mark the number in red?
i think conditional formatting can work for that.
Proud to be a Super User!
Here is a workaround for you, you can create columns to find out the percentage that you need to mark.
Proud to be a Super User!
@ryan_mayu Thanks for your response. I understand the conditional format but what the query should look for if the value is less than 75% for any 3 months of the rolling 6 months then apply conditional format
Here is a workaround for you, you can create columns to find out the percentage that you need to mark.
Proud to be a Super User!
do you mean mark the number in red?
i think conditional formatting can work for that.
Proud to be a Super User!
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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
138 | |
106 | |
103 | |
74 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |