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
Greg_Deckler
Community Champion
Community ChampionPlease 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