Reply
Regular Visitor
Posts: 44
Registered: ‎08-05-2016
Accepted Solution

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


Accepted Solutions
Established Member
Posts: 173
Registered: ‎05-27-2016

Re: Selection list for column names.

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


Regards.

Pavel

View solution in original post

Highlighted
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Selection list for column names.

[ Edited ]

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.

View solution in original post


All Replies
Established Member
Posts: 173
Registered: ‎05-27-2016

Re: Selection list for column names.

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


Regards.

Pavel

Highlighted
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Selection list for column names.

[ Edited ]

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.