cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mtozero Regular Visitor
Regular Visitor

Re: Power BI Table In the UI

@freder1ck  Appreciate again your response. 

 

Attached the screenshot of what has to change properties dynamically.

 

 

 

freder1ck Member
Member

Re: 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. 

Mtozero Regular Visitor
Regular Visitor

Re: Power BI Table In the UI

thanks, @freder1c Capture.PNGI want the name Month-Year has to be dynamically changed (Measure Name).  Can you share the example of conditional formatting 

freder1ck Member
Member

Re: Power BI Table In the UI

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. forums 20180105.png

 

 

Above or Below Average =
[Average Period Sales] / CALCULATE([Average Period Sales], ALL(Territories ))

 

Link

 

Good luck! Let me know how it goes.

 

Fred 

freder1ck Member
Member

Re: Power BI Table In the UI