Forum Discussion

ddalton's avatar
ddalton
Resolver I
4 years ago
Solved

Hiding Table Visual columns affects shown rows

Hi,

 

I have a Visual Table with several Filters and Slicers applied (Customer, Date Range, Reference, Value) resulting in this representative output:

IndexReferenceDateCustomerItemCodeValue
1X101/01/19810011A300
2X105/05/19850011B180
3X105/05/19850011B160
4X107/07/19870011B250
5X107/07/19870011C700

 

When the Index column is included (as above) I see 5 rows. When the Index column is removed from the Visual Fields I see only 4 rows, as below: 

 

ReferenceDateCustomerItemCodeValue
X101/01/19810011A300
X105/05/19850011B340
X107/07/19870011B250
X107/07/19870011C700

 

Essentially, it's grouping the rows by the Date column (because there's no longer any reference to the unique Index column). I understand why that's the expected behaviour but I would like to still see all 5 rows (i.e., all unique Index rows) while keeping the Index column hidden from view. 

 

I tried to add the Index Field to the Filters section of the Visual (i.e., without adding it as an actual Field/Column) as proposed in similar posted topics but that still results in showing only 4 results instead of 5. 

 

I might be able to resolve it through a Table relationship (maybe, and I can look into that separately) but I'm wondering if there's a "frontend" GUI solution in Desktop. 

 

Two worst cases are that I either just show the Index column anyway (depsite that it doesn't strictly show any useful value) or I can use the rather ugly solution of just hiding that particular column with another Visual or some other dashboard element. 

  • Hi, ddalton 

    You don't need to hide that particular column with another Visual.

    Please try follow steps:

    1. Go to Table visual "Formatting Pane" and turn off all options regarding "Word Wrap"

    2. Drag the table 'Index' column border to resize the table column width to 0 to hide the 'Index' column

    Best Regards,
    Community Support Team _ Eason

2 Replies