Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
umutkaya79
Helper I
Helper I

1 Slicer for 2 line charts on the same page

Hello,

I have a question if anyone please suggest a solution.

 

I have 2 line charts and one dataset has data coming from 2 different tables. (I did join those 2 tables in SQL before importing into PowerBI).  I am trying to use only 1 slicer which would filter both line charts. I cretaed 2 slicers and sync them. It works perfect but I am trying to display only one of the slicers on the page. If I get rid of one of the slicers remaining one won't filter the 2 line charts. It will only filter one of them since the dataset is from 2 different tables. 

 

Thank you 

 

umutkaya79_0-1678219659907.png

 

3 REPLIES 3
jdbuchanan71
Super User
Super User

You would either have to 

A. Put a table with the selection options in the model that links to both tables and use that.

B. Look at TREATAS to write the measure for the second visual using the selection from the first table.
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

 

jdbuchanan71
Super User
Super User

Can you set the 2nd slicer to hidden since the synch is working?

jdbuchanan71_0-1678220444480.png

 

I did that too actually but I am not allowed to use that option. Thank you though. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.