Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
So, you would want to unpivot those columns as suggested by @DaFloDo
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |