Forum Discussion
Change Table Columns Based on Slicer Selection
Hi All, I'm looking for a way to switch out columns in a table if a selection from a slicer is made. Example Year Slicer = 2021, show Columns A, B and C in my table or if Year Slicer = 2022, s...
Hello, could you please elaborate the below part in your solution?
YearColumnMapping → Columns Lookup → Fact Table
What's the steps in 'Columns Lookup againt Fact Table'? Thanks a lot.
MohamedFowzan1
Super User
Super UserPosting screenshots of Paramters, dataset and DAX for better understanding:
Ref 1:
Ref2:
Ref3:
Ref4:
Ref5:
Actual table:
Ref6:
Unpivot table:
Ref7:
Relationships:
This would be a starting point for you to play around with actual data and build on it.