Forum Discussion
Dynamic column picker using a new table
Hi, I am stumbling across this problem for quite some while now but cannot resolve it. I draw a quick sketch of my thought and the given data/information. So basically, I have a large table. Each...
diewalchin , Based on what I got. You need to unpivot the first table and need to have table with column and group to filter joined with this table
amitchandak thank you for the quick reply!
Yes, I also thought about it. This means that I should unpivot the columns, which means that my column headers are then in one column and a second column contains the respective values, and the date column stays untouched, right? Am I assuming it right that you would then create a new column that contains the group names (if column_header = 'AB', then 'group1',...) so that this column can be then used as a slicer?
I have further two questions:
- Do you have experience if the unpivoting also works for direct query data? So are the data then in the unpivoted table continuously updating?
- What if I want to use 3 visuals that are influenced by 3 slicers. All three slicers have the groups and the three visuals are updating dependent on the slicer selection. Do I then have to create 3 unpivoted data or can I use just 1 unpivoted data table? When I apply the "interaction concept" by enabling or disabling a cross-filter, then one table would be appropriate, or?
