Hide & Show the columns based on selections in filter values

[Yuvaraj]

Hi,

I have table with more columns and its difficult to scroll and view the data,

In default it shows the data for all columns when i selected the filter value it should show the selected value only in table.

For example,

Filter

1

2

3

4

5

Table default view:

1 2 3 4 5

Once i selected the filter then the table should show the selected column value. If I selected filter value as 1 & 2 then the table will shows only column 1& 2 in table.

Table 

1 2

if i uncheck the value 1 then it should show the value 2 only in table.

Table

2

Regards,

Yuvaraj

[ryan_mayu]

Maybe you can download slicer hierachy in the market and drill down your filters.

[v-juanli-msft]

Hi @Yuvaraj

Based on my knowledge, a slicer only accept a column contains multiple values.

Like a column with value 1,2,3,4,5

Then select 1 in that slicer, the table would show row of 1 for that column.

I'm afraid it is not possible to achieve your requirement directly by the slicer and table visual.

If you could accept any transforms of the dataset, i would recommend you to use 'unpivot columns" in the Edit Queries.

Please let me know if you have any question.

Best Regards

Maggie

[Yuvaraj]

Hi,

Thanks for your response.

I have tried Hierarchy Slicer and Unpivot columns but the user asking above mentioned method which I have posted, is that possibile to acheive.

Regards,

Yuvaraj

[v-juanli-msft]

Hi @Yuvaraj

From you last post, it seems your problem regarding slicer has been sloved, right?

Best Regards

maggie