Forum Discussion
Dynamically hide table columns without column slicer
Hi - Just in case anyone has a similar problem.
I left this project alone for 6 weeks and when I came back to it, the solution was actually very easy.
Bottom line is that I could create a Field Parameter table from my list of measures. However I wanted to use an existing slicer to slice the Parameter table and not do it directly. An easy way to do this is to create a join table between the table my original slicer is working on and the new parameter table. Then just create relationships from the new join table to the original table and the Parameter table. This results in being able to use the original slicer to slice both tables. I did need to mess around with the filtering direction as I had many to many relationships on both sides of the join table, But this works like a charm.
Hi - Just in case anyone has a similar problem.
I left this project alone for 6 weeks and when I came back to it, the solution was actually very easy.
Bottom line is that I could create a Field Parameter table from my list of measures. However I wanted to use an existing slicer to slice the Parameter table and not do it directly. An easy way to do this is to create a join table between the table my original slicer is working on and the new parameter table. Then just create relationships from the new join table to the original table and the Parameter table. This results in being able to use the original slicer to slice both tables. I did need to mess around with the filtering direction as I had many to many relationships on both sides of the join table, But this works like a charm.