topic Re: Slicer to switch column in Report Server

Slicer to switch column

XeniaLi — Wed, 25 Oct 2023 16:58:30 GMT

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.

Re: Slicer to switch column

lbendlin — Thu, 26 Oct 2023 22:36:22 GMT

Do you have bookmarks?

Re: Slicer to switch column

XeniaLi — Mon, 30 Oct 2023 08:35:28 GMT

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

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

Re: Slicer to switch column

lbendlin — Mon, 30 Oct 2023 21:41:08 GMT

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.

Re: Slicer to switch column

XeniaLi — Tue, 31 Oct 2023 08:24:25 GMT

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.