Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Smit
Regular Visitor

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!

1 REPLY 1
Eric_Zhang
Microsoft Employee
Microsoft Employee


@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.

 

Capture.PNGCapture.PNG

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.