Syncing slicers

[Thulasiram]

Dear all

I have a calender table with dates, Financial Year, Month (MMM-YY) and Month (MMM) formats.

I have 4 Financial years and respective MMM-YY and MMM

I have created two slicers - 1. with Month(MMM-YY) and 2. with (MMM).

I want to sync both the slicers through "sync slicers" option but I am not able to.

If I create both the slicers with same column like (MMM-YY) it is syncing.

But if I use two diff columns from the same cal table, it is not syncing.

Is it possibe to achieve this?  Pls guide.  Thanks.

[Anonymous]

Hi @Thulasiram 

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

[Anonymous]

Hi @Thulasiram 

You are right that the synchronous slicer function in Power BI usually requires the slicer to be based on the same column.

Unfortunately, there is no direct shortcut to synchronize slicers based on different columns, even if they come from the same table.

However, you can achieve similar functionality with a workaround. You can create a new calculation that combines the values from the different columns to be synchronized. Then, use this new column as a slicer.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Thulasiram 

The sync slicer function only works if the slicer is based on the same column.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thulasiram]

Hi @Anonymous ,

Thanks for reply and clarifying.  No shortcuts to make it work even if the columns are from the same table?  Just curious to know.  Thanks.

[PijushRoy]

HI @Thulasiram 

Please share screenshot of the requirement 
Please find the article - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...