Desktop

[ahsanlhcgov]

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. 

Please can someone look and advise if that is possible

[PavelR · Accepted solution]

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

Regards.

Pavel

[MattAllington · Accepted solution]

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

[PavelR · Accepted solution]

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

Regards.

Pavel

[MattAllington · Accepted solution]

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