Forum Discussion
Anonymous
3 years agoNot applicable
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
| FY | PID | Col2 | Col3 | Col4 | Col5 | Col6 |
| FY22 | 100 | 10% | 90 | 95 | 10 | 14% |
| FY22 | 150 | 8% | 140 | 145 | 40 | 12% |
| FY22 | 125 | 7% | 115 | 120 | 20 | 11% |
| FY23 | 130 | 8% | 120 | 125 | 22 | 12% |
| FY23 | 145 | 9% | 135 | 140 | 28 | 13% |
| FY23 | 160 | 6% | 150 | 155 | 30 | 10% |
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:
| PID | Col2 | Col3 | Col4 |
| 130 | 8% | 120 | 125 |
| 145 | 9% | 135 | 140 |
| 160 | 6% | 150 | 155 |
"FY22" Slicer selection output:
| PID | Col2 | Col3 | Col4 | Col5 | Col6 |
| 100 | 10% | 90 | 95 | 10 | 14% |
| 150 | 8% | 140 | 145 | 40 | 12% |
125 | 7% | 115 | 120 | 20 | 11% |
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