Forum Discussion
Conditional Formatting in Power BI using measures.
I need to implement the same conditional formatting in Power BI using a measure that apper in below excel sheet. I have two data sheets in Excel. 1) Dashboard 2) Data for conditi...
Hi Manav-Shah
I would like to apologize for the belated reply.
If your problem is not solved yet, can you tell me how month value is obtained?
Best Regards,
Yulia Xu
I have data in below format
then I used countifs funcrtion for calculating all months total.
For conditional formatting, I intend to set conditions based on the average of the last three months multiplied by 140%. For instance, when applying conditional formatting for January, it is computed by taking the average of October, November, and December and multiplying it by 140%. Similarly, for February, it is calculated using the averages of November, December, and January, then multiplied by 140% and so on for other months.