Slicer to switch column

[XeniaLi]

Hi guys, is there way to create a slicer to select columns.

We are reporting on Report Server so field parameters are not available.

Unpivot table is not an option, we have different value types, dates, strings, numbers, we want to keep it.

Much appreciated help.

[lbendlin]

Do you have bookmarks?

[XeniaLi]

We do, how can I use it in this case please?

The table contains 100+ column, different users might want to see different combinations.

[lbendlin]

On a standard Power BI I would say "Enable Personalize Visuals and teach your users how to use that".  But I don't know if that option is available on premise.

[XeniaLi · Accepted solution]

Thank you for looking into it, unfortunately this option is not available on premise.

We opted for pagenated report for now, which is not great but works.