Solved: Hiding Table Visual columns affects shown rows

ddalton · ‎06-10-2022

Hi,

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

Index	Reference	Date	Customer	Item	Code	Value
1	X1	01/01/1981	001	1	A	300
2	X1	05/05/1985	001	1	B	180
3	X1	05/05/1985	001	1	B	160
4	X1	07/07/1987	001	1	B	250
5	X1	07/07/1987	001	1	C	700

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:

Reference	Date	Customer	Item	Code	Value
X1	01/01/1981	001	1	A	300
X1	05/05/1985	001	1	B	340
X1	07/07/1987	001	1	B	250
X1	07/07/1987	001	1	C	700

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.