Forum Discussion
Table visual - group by
Have you tried setting this as a Matrix instead of a table?
Note: I've turned 'Stepped Layout' off (under Row Headers). I've not applied most of the stuff in your post, but they are all available. You should be able to simply select your existing table, click on "Matrix" and then ensure your Region and Location columns are under the "Rows". You can turn all the totals off as well.
Hi Ross,
I have tried with Matrix visual initially and was able to get the solution BUT the issue i am facing is - unable to set the background color to RegionName column value. Seems as of now Matrix visual doesnot support the conditional formatting to set the background color to column values. I have submitted an idea in powerbi forums to include this feature. ( https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36010816-conditional-formatting-to-set-background-color-to )
Please refer the below Matrix visual for reference.
I have tried a work around:
Instead of Matrix visual, i have used Table visual to apply Conditional formatting to set background color to the column values.
please provide inputs using Table visual.
Thank you.
Ahh got ya. Yeah i forgot the Row and Column headers can't be conditionally formatted. Now i see the limitation you are facing.
I think you might be stuck unless the idea you have raised gets implimented. Tables don't have the "as above" type empty spacing.