Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Tony5
Helper I
Helper I

Unpivot columns dynamically

‎05-23-2019 09:09 PM

I have a similar issue to the forum post from Oct 2018.

 

Just want to check in if that's a possibility now? In my case, I'm specifically looking to unpivot the selected columns. But similarly, I expect to receive a different number of columns per month. The only thing constant is that they will have the same prefix.

Message 1 of 3
851 Views
0
2 REPLIES 2
parry2k
Super User
Super User

‎05-25-2019 05:48 AM

@Tony5 link you shared is not working. share some sample data and expected result. read this post to get your answer quickly

 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 3
827 Views
0
Tony5
Helper I
Helper I
In response to parry2k

‎05-27-2019 09:12 AM

Thanks for the response @parry2k .

 

i've edited my link up top. I've also uploaded a sample dashboard here.

 

Essentially, I wanna go:

From this...From this...To this...To this...

But instead of hardcoding column names, is there a way to unpivot by selecting column prefixes (="save_"*)? or dynamic column numbers (>=column4)?

Message 3 of 3
808 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All