Forum Discussion

Smit's avatar
Smit
Regular Visitor
9 years ago

Reporting dynamic number of attributes generated by pivoting up

Hi,

 

I have a requirement to pivot up a column, where number of attributes may increase in future.

 

For example, I have a column Department, with values 'Dept1' and 'Dept2', which on pivot up gives me two columns 'Dept1' and 'Dept2'. These columns can be pulled in my Power BI reports.

 

Now in future there is one more dept 'Dept3' added to the Department. Now the pivot up gives me three columns 'Dept1', 'Dept2' and 'Dept3'. Is there a way to dynamically include these columns in the Power BI report (so that I can avoid manually pulling the new column in the report, every time a new dept is added?

 

Thanks!

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago
    Smit wrote:

    Hi,

     

    I have a requirement to pivot up a column, where number of attributes may increase in future.

     

    For example, I have a column Department, with values 'Dept1' and 'Dept2', which on pivot up gives me two columns 'Dept1' and 'Dept2'. These columns can be pulled in my Power BI reports.

     

    Now in future there is one more dept 'Dept3' added to the Department. Now the pivot up gives me three columns 'Dept1', 'Dept2' and 'Dept3'. Is there a way to dynamically include these columns in the Power BI report (so that I can avoid manually pulling the new column in the report, every time a new dept is added?

     

    Thanks!

    Smit

    There's no such dynamically way. May I know why you'd like to pivot the column, maybe you don't need to do that at all, just put that column to legend field in a visual or put that column to column field in a matrix visual.