Hi
Please see the attached file and see below the steps I would like to achieve in this file by power query or power pivot so it is automated when a new month data comes in monthly. I need these if conditions to create a red, yellow, and green dynamic pivot chart. I would really appreciate your help in achieving it.
After the above steps, pivot chart to create example below:
Bookmarks