Filter by Male/Female when just given Numbers

[bw70316]

I have a list of months for the last FY which includes totals for Men/Women for each month. When I try to filter by just one or the other, I see no changes in my data because the totals are related to the month in question. For example, when I do a list and click on that number, it highlights the coorresponding month for that number. Is it possible, with just numbers, to filter by gender?

[bw70316]

So I am trying to take this data and filter it my Male and Female. These are totals. I am assuming this can be done in some way, or would I need the original data to illustrate male/female. Sorry for the poor post above, I was in hurry for a meeting

[Greg_Deckler]

So, you would want to unpivot those columns as suggested by @DaFloDo

[Greg_Deckler]

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

[DaFloDo · Accepted solution]

hi @bw70316,

you could try the "UNPIVOT" function in power query when the data is loaded

another way would be using DAX to try like here

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

best regards 

florian