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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
parthpatelalex
New Member

Slicer Sync Issues

Hello Community I am trying to sync multiple slicers from different data source in which all them have common data values, I am not able to sync them properly. like have Columns named - Client, Months, Processes from different data sources/Tables but whenever I am trying sync them together for main visualization page it won't give me true output. Also tried to use Parent data labels for all the common mentioned columns so can easily create relationship between tables. But still I am stuck, please help me out.
Below is the data sample
 

parthpatelalex_0-1712126853823.png


Thank you in advane 🙂

1 REPLY 1
belvoir99
Resolver III
Resolver III

The best way to solve this is to follow best practice and create dimension and fact tables aka star schema - see Microsoft Power BI best practice articles - https://learn.microsoft.com/en-us/power-bi/guidance/star-schema.

 

You have a Calendar table - this is a dimension table which should be joined (aka create relationship) to the other tables (facts) on the Date column (or Month column for Feedback fact table*). You need to mark it as a Date table. Make sure the dates start on Jan 1 and end on Dec 31, ie a complete year.

 

You need a separate Client table: one column with the names of all the clients. You can create this separately or use Power Query to do so (but might be a bit tricky with a number of different columns in fact tables). Load that into the model and then join that to the fact tables.

 

You mention Processes; but there are no Process columns in your image. If Process is a shared column then follow the same procedure as Client above and create a separate table and join it to the fact tables.

 

Once you have done so, then use the columns from the Dimension tables (Calendar, Client, Process) for row headers, column headers, slicers etc. Any filtering from these dimension tables automatically propagate to the fact tables. You can then easily sync between one page and another, or between visuals. 

 

*Feedback table: it's better if possible to add a Date column here rather than just have a Month column.

 

Hope that helps!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors