Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
This was answered on stackoverflow:
https://stackoverflow.com/questions/53448876/powerbi-slicer-affect-only-one-table/53449014#53449014
This was answered on stackoverflow:
https://stackoverflow.com/questions/53448876/powerbi-slicer-affect-only-one-table/53449014#53449014
Hi @Anonymous
It seems you've got the answer, right? If so, please accept your reply as solution to close this thread.
Regards,
Cherie