Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Transpose/Dynamic Columns based off Slicer

Hi, Im trying to transpose my data and have the columns shown be dynamic based off a related slicer My base data looks like this: I then transpose to this, which is the format I'm looking to...
Need Help
ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Anonymous#w ,

having difficulties to understand what's requested here. 

First impression was that you shouldn't unpivot your data.

You're starting from a table with a defined structure and fixed number of columns and transform it to a table with an unknown number of columns (and therefore column names). Why do you do that?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

     

     

     
    • ImkeF's avatar
      ImkeF
      Community Champion
      6 years ago

      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?