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.
Hi,
Here is what I am thinking to do, and getting stuck in Power BI.
Let's say, I have a table with 4 columns; "Year", "Gender" "Smoker Status" and "number of people"
Part 1. How many % of people are Male or Female each year? For example, in 2012, Male: 45% and Female: 55%...
Part 2. Starting from part 1, is there way to show like... WITHIN the 45% male in 2012, how many % are smokers?
What I want to do is basically displaying those information above as a form of visualizations with options of filtering.
I somewhat handled Part 1, BUT when I try to do the part 2, it shows % of smokers in OVERALL... not % within my filter, which is male..
That saying, if 45% are Males in 2012 and 50% of them are smokers, what I wanted to see is "50%" when I filter with male and smoker, but what i see is 22.5%, which is 50% of 45%.
Would you anyone help me out with this problem?
Hope my explanation makes sense.
Thanks,
Solved! Go to Solution.
Hey,
see my answer here:
https://community.powerbi.com/t5/Desktop/POWER-BI/m-p/478056#M222441
Regards,
Tom
Hey,
see my answer here:
https://community.powerbi.com/t5/Desktop/POWER-BI/m-p/478056#M222441
Regards,
Tom
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |