Reporting dynamic number of attributes generated by pivoting up

Smit — Thu, 24 Aug 2017 05:56:58 GMT

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!

Re: Reporting dynamic number of attributes generated by pivoting up

Eric_Zhang — Fri, 25 Aug 2017 01:50:53 GMT

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.

topic Re: Reporting dynamic number of attributes generated by pivoting up in Developer

Reporting dynamic number of attributes generated by pivoting up

Re: Reporting dynamic number of attributes generated by pivoting up