Forum Discussion
Power BI Table In the UI
Mtozero wrote:thanks freder1ck for your response. Appreciate your support.
My problem is with the disconnected table since we need to more slicers.
So what I was thinking let's assume there is no disconnected table. If I can add 12 measures (DAX for each month). It might work but the problem is how to make the measure name/column name dynamically changing.
Could you describe a bit more the final result you're looking for? The results here can be sliced by Country, Territory, etc. You could even add a slicer on the disconnected table to show only specific columns. Are you looking to slice according to year and month instead of current state?
freder1ck Appreciate again your response.
Attached the screenshot of what has to change properties dynamically.
thanks, @freder1c I want the name Month-Year has to be dynamically changed (Measure Name). Can you share the example of conditional formatting
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.
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