Show only selected data on matrix when sliced

[brinky]

Hello,

I'm creating a report with a matrix showing slaes data for 2019 vs. 2019, I also created 3 slicers so user can sellect accodingly all works well.

Then I have created a measure to show % differnce from 2019 and 2019.

My problem is that when I use a slicer to select a brand all data is showing on matrix whereas I would that the only brnad shows on the matrix.

Any idea how to get this ?

Thanks in advance

[amitchandak]

I think you are comparing 2018 with 2019.

In case your filtering bard and it is not working. It can be an issue because the relation is not there or because of edit interactions.

Check the relation view and see if something is missing.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[brinky]

@amitchandak 

Thanks for your reply realasionship seeems good, well I suppose