Slicer only affect one table

[Anonymous]

I have 3 tables.

Table0 contains the column DateTime0

Table1 contains the columns DateTime1 and Price1.

Table2 contains the columns DateTime2, Price2, and Unit2.

I've linked DateTime0 with DateTime1, and DateTime0 with DateTime2.

I can put in a line plot of Price1 and Price2 as y-axis and DateTime0 as x-axis.

I can put in a slicer of DateTime0, and this then affects my line plot as expected.

I now want to put in a slicer of Unit2, such that Price2 displayed on my line plot would only come from those selected. But If I do this then my Price1 line dissapears, because it is also filtered.

How do I make it so that the slicer only affects the data coming from Table2?

I know I can do this with 2 seperate plots, but I want to be able to do it with one plot.

[Anonymous · Accepted solution]

This was answered on stackoverflow:

https://stackoverflow.com/questions/53448876/powerbi-slicer-affect-only-one-table/53449014#53449014

[v-cherch-msft]

Hi @Anonymous

It seems you've got the answer, right? If so, please accept your reply as solution to close this thread.

Regards,

Cherie