Forum Discussion
Field parameter slicer to add extra columns in table visual
If the goal is to show or hide two specific columns using a slicer, there’s no need to add everything to the parameter table. Add the columns or measures for those two columns first, then add the parameter, followed by the remaining columns or measures. Any columns or measures not coming from the parameter table will not be affected by the slicer selection.
Super UserHi Millabu
You threw me a curve ball with this but (I think) i managed to replicate this behavior. Kind of. I can't get it to work with the classic slicer, but I can with the new one (but it looks different):
I added the parameter to the new slicer (you can format it to a vertical list but it wont have the selection boxes, rather its a bunch of cards. I selected by hand ALL of the parameters. The order in which they were selected decides the column order. I duplicated the slicer. Only on the second slicer I added a visual level filter to filter it to the category and lifecycle columns. Then I simply hid the first slicer (View>Selection>Hide visual) and this is what I was left with:
It has the behavior you want but I cannot format it the same way.
Could you check:
- if this works for you for your recreation
- which type of slicer visual is used in the original project you took the screenshots of
- if there is a hidden slicer on the report page in the original project as well
Hello, and thank you so much for puttig effort on solving this! You asked:
- which type of slicer visual is used in the original project you took the screenshots of --> List slicer (new slicer)
- if there is a hidden slicer on the report page in the original project as well --> there are no hidden slicers
I tried to replicate what you did, and maybe I'm just not seeing something or then there is another reason my table visual is not behaving same way as yours:
1. I added a slicer (List slicer) and a table visual on a report page. I put the Parameter in the table visual values, and after that I selected ALL the values in the slicer.
2. I duplicated the slicer and I added a visual level filter to filter it to the category and lifecycle columns. And then I hid the first sicer.
3. Left with this, I havea table with all the columns, and when I choose a value or boht values on the slicer, the table only filters to those ones and does not show the rest of the columns. Below are the screenshots to demonstrate this.
I don't understand what I'm missing here 😅