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
