how to display column in (Matrix or Table) visual and add conditional formatting.

[Anonymous]

Hi,

Based on below Sample Table Data, I have tried and able to display the data in Matrix visual as below,  BUT  need help 

 

Need help and inputs:

1) how to display Region as a column in Matrix visual ?

2) how to add conditional formatting  to the Region column value to set some background color.

If the  requirement (points 1 & 2 )can be acheived in Table visual then it will also help 

Expected Visual mockup:

 

Sample Table Data

Region	Location	Item	Volume
Region1	Location4	Item2	44
Region1	Location4	Item1	44
Region1	Location4	Item6	55
Region1	Location2	Item4	44
Region1	Location3	Item2	44
Region1	Location3	Item1	44
Region1	Location3	Item8	44
Region1	Location3	Item4	44
Region1	Location3	Item3	44
Region1	Location3	Item6	44
Region1	Location3	Item5	44
Region1	Location3	Item7	44
Region1	Location1	Item4	44
Region1	Location1	Item7	44
Region1	Location5	Item4	55
Region1	Location5	Item7	55
Region1	Location7	Item2	55
Region1	Location7	Item8	66
Region1	Location7	Item4	55
Region1	Location7	Item3	55
Region1	Location7	Item6	55
Region1	Location7	Item7	66
Region1	Location6	Item4	55

Thanks.

[Anonymous · Accepted solution]

Thought to share :  I was able to display Region column using Matrix Visual

Below are the steps,

1)   Select the Matrix visual --> Click Format icon --> Go to Row headers and turn off the "Stepped Layout" feature.

      

2)  Drag the RegionName  to the Rows Field.