Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Table visual - group by

Hi, Based on below Sample Table Data, I have tried and able to display the data in Table visual.  Refer Image 1            Region Location Item Volume Region1 Location4 Item2 2968 ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.