Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Show Different Columns Based On Filter Selection

Hi,

So what I want is to return multiple columns from a particular table into a matrix visual based on a particular filter selection.

 

Say, there is a table

FYPIDCol2Col3Col4Col5Col6
FY2210010%90951014%
FY221508%1401454012%
FY22

125

7%1151202011%
FY23130

8%

1201252212%
FY231459%1351402813%
FY231606%1501553010%

 

Now, in the output matrix what I desire is that in the rows Project Id will be there and if in the slicer "FY23" is selected then in the output matrix table, the columns will be returned dynamically such only Col2 till Col4 will be visible and then if "FY22" is selected in the slicer all columns will be visible in the output Matrix table.

 

"FY23" Slicer selection output:

PIDCol2Col3Col4
130

8%

120125
1459%135140
1606%150155

 

"FY22" Slicer selection output:

PIDCol2Col3Col4Col5Col6
10010%90951014%
1508%1401454012%

125

7%1151202011%

 

Is there a way to dynamically change the output columns to be displayed based on slicer selection. (For a matrix table visual)

 

Thanks & Regards.

No Replies