How to set right filtering

[IJNiklas]

Hi,

I´m very new to PowerBI and I must say it is an amazing tool. I started to build reports with data from our business system. I haven´t figured out the way to get the filters right. We have a lot of articles in our system that we sold 2-3 years ago and don´t sell anymore. So when I make my report and I for example chosse 2016 I only what to see the articles I´ve sold that year but still I get every article that I have in my database. 

So basically I only want to see the articles I´ve sold from that year and if I after 2016 choose to see what I´ve sold in January I only want to see those articles in the drill-down menu.

Or if I choose a customergroup I only want to see the articles that I´ve been selling to that group. 

I hope I explain the problem so it makes sense.

Thanks in advance,

Niklas

[carlosDash]

I think more information on the way your data is structured would help. It's difficult to answer your question without knowing more details.