Forum Discussion
Slicer only affect one table
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.
- Anonymous7 years ago
This was answered on stackoverflow:
https://stackoverflow.com/questions/53448876/powerbi-slicer-affect-only-one-table/53449014#53449014
2 Replies
- AnonymousNot applicable
This was answered on stackoverflow:
https://stackoverflow.com/questions/53448876/powerbi-slicer-affect-only-one-table/53449014#53449014
- v-cherch-msftMicrosoft Employee
Hi Anonymous
It seems you've got the answer, right? If so, please accept your reply as solution to close this thread.
Regards,
Cherie