Forum Discussion
Conditional Formatting of Area Chart
Hi oliverblane ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
Hi Anonymous, thank you for your reply. Here is a link to a sample version of the mentioned report with desensisitized data: Example_Dashboard.pbix
The desired results are as follows. When an end date is selected on the date slicer, two measures are calculated:
M1) Number of registrations in the 30 day window leading up to the end date
M2) Number of registrations in the previous 30 day window (any registrations between 60 days and 30 days before the end date).
The KPI visual currently shows red if M1 < M2, and green if M1 > M2, as expected. I would also like the cumulative area chart to change colour too, like this:
and
Currently, it works when M1 > M2, but when M1 < M2, the following shows:
Thanks again for your help on this!