Forum Discussion
bw70316
Helper V
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 t...
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
bw70316Helper V
Helper V
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
Community Champion
Community ChampionSo, you would want to unpivot those columns as suggested by DaFloDo