Forum Discussion

kimx3263's avatar
kimx3263
New Member
8 years ago
Solved

Multi-filtering in Power BI

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,