cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ahsanlhcgov Regular Visitor
Regular Visitor

Selection list for column names.

Hi. Can someone please help me with this one. 

 

I have a table for all the expensenes monthly sliced. I need to have 1 column and have all the months as a selection so which ever I select it should show that months figures. 

periodic.PNG

 

 

 

Please can someone look and advise if that is possible

2 ACCEPTED SOLUTIONS

Accepted Solutions
PavelR Established Member
Established Member

Re: Selection list for column names.

@ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.


Regards.

Pavel

Super User
Super User

Re: Selection list for column names.

You need to unpivot your data during the get data process. 

 

Here is an old video I created. The principle and approach is the same in Power bi

https://m.youtube.com/watch?v=K7VS5oqjCxU



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
2 REPLIES 2
PavelR Established Member
Established Member

Re: Selection list for column names.

@ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.


Regards.

Pavel

Super User
Super User

Re: Selection list for column names.

You need to unpivot your data during the get data process. 

 

Here is an old video I created. The principle and approach is the same in Power bi

https://m.youtube.com/watch?v=K7VS5oqjCxU



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 286 members 3,048 guests
Please welcome our newest community members: