Hi,

Based on below Sample Table Data, I have tried and able to display the data in Table visual. Refer Image 1

i have applied Conditional formatting to set background color to the column values.

Below are steps and Refer Image 1:

1. Used Table visual.

2. Created below columns (using New Column option) in RegionBreakdown table.

VolumeCheck = if(((RegionBreakdown[Volume]=0) || (RegionBreakdown[Volume]=BLANK())),BLANK(), RegionBreakdown[Volume])

Item1 = If(RegionBreakdown[ItemName] = "Item1", RegionBreakdown[VolumeCheck], 0)

RegionColor = if( MAX( RegionBreakdown[RegionName] )="Region1", 1 ,2 )

3. Table Fields - dragged RegionName, LocationName, Item1 to the Values.

4. on RegionName Value - i have applied Conditional formatting to set background color to the RegionName column values using RegionColor condition.

Image 1

Need help on the below Requirement.

Requirement: Can we groupby RegionName column value in Table visual something like below as in Image 2 ?

Image 2 - Expected behavior

Thankyou

Forum Discussion

Table visual - group by