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,
