Forum Discussion
Transpose/Dynamic Columns based off Slicer
Hi,
Thanks for the feedback! The way the data is originally stored with the fixed structure does not meet the requirement as the goal is to replace a manual process with minimal layout change. All of the columns in the base data are attributes to the Contract Plan ID. Since a Contract Plan ID has roughly 100 attributes, it reads easier if the attributes are listed out in rows instead of columns as there will be at most 10 Contract Plan IDs
Its almost as though I need to apply the slicer prior to transposing the data to get the correct Contract Plan IDs to show however I havent found a way to do this as the slicer is dynamic as well
For me a slicer is an element on the report canvas. But as we're in Power Query land here: What do you mean with that here exactly?
A filter on a column?