Forum Discussion
Helper VFilter by Male/Female when just given Numbers
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?
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
4 Replies
DaFloDoResolver I
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
- Greg_Deckler
Community Champion
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
- 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
