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.
Thank you for looking at this.
This is interesting and should work, I will try it today and either ask more questions or let you know if I have success (and marking your solution as the accepted one).
I need to take the time to understand your example properly then apply it to my data. I will definitely do that.
I was trying to not use a matrix and rather use a simple table, as the measures i currently display here are all used in many other visuals. The actual calculation of the values in the measures in my 20 "Year" columns have been tested and proved in other visuals and reports. Also there are a bunch of other columns that need to go to the right of the age columns - I may have to move those into a seperate table. My table currently displays correctly - I just end up with some blank columns that i was hoping to hide using the selected value from the existing Age slicer and not using a new slicer for the columns.
Hi amitchandak
I took a try and ended up in exactly the same quandry here. I end up with blank columns in my Matrix. So I downloaded your Cohort Analysis from the above link, and added a slicer for your main date table (essentially that is what I am doing) to only show MonthYear column for 2019 and later. Your solution also now has empty columns:
Yes - it is easy enough to add another slicer for the "First Date" table to remove those columns but that is precisely what I do not want to do. I want to use your selected value from the "date" slicer in order to dynamically set your "first date" slicer or somehow use that value to hide the blank columns in the Matrix.
Any ideas?
Thanks