Forum Discussion
Power BI Table In the UI
Mtozero wrote:freder1ck Appreciate again your response.
Attached the screenshot of what has to change properties dynamically.
I don't see the screenshot... By the way, I have a workaround for the conditional formatting you need.
If you add a second measure that is the percentage of the whole, you can add that to your matrix and add conditional formatting of the background. If you don't want to see the numbers, resize the column to be really thin. You would need to turn off autosize for the columns.
thanks, @freder1c I want the name Month-Year has to be dynamically changed (Measure Name). Can you share the example of conditional formatting
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