Forum Discussion
Solved
Power BI Table In the UI
We have a requirement to display the data in power BI with the below format. (a) Columns as Rolling 12 months,(show individual month), Previous 12 Months overall total, Current 12 Months and the...
You want to slice on Month Year? It sounds like 15 measures may be the way to go. You can still get the average in the total using Averagex.
And for the conditional formatting, I would do something like this.
Above or Below Average =
[Average Period Sales] / CALCULATE([Average Period Sales], ALL(Territories ))
Good luck! Let me know how it goes.
Fred