- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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!
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-29-2024 12:05 AM | |||
10-16-2024 08:32 AM | |||
01-23-2024 03:16 AM | |||
01-02-2025 10:43 AM | |||
07-02-2023 06:27 AM |