Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Date slicer advanced sync

Hi all,   I am currently working on a Power BI report and need a little bit of assistance in regards to a date slicer.   So I am looking at sales of items and want one of my tabs to be a selected...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

    Sales: = 
SUM( sales[sales] )

     

     

    Sales 3 weeks prior: = 
CALCULATE (
    [Sales:],
    'calendar'[date]
        >= MIN ( 'calendar'[date] ) - 27,
    'calendar'[date]
        <= MAX ( 'calendar'[date] ) - 27
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

 

Sales: = 
SUM( sales[sales] )

 

 

Sales 3 weeks prior: = 
CALCULATE (
    [Sales:],
    'calendar'[date]
        >= MIN ( 'calendar'[date] ) - 27,
    'calendar'[date]
        <= MAX ( 'calendar'[date] ) - 27
)

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

This is really good, but is there a way for me to have two tabs, one with the selected date range on a slicer that is linked with another slicer on the second tab that has the last 3 weeks. 

 

Here is example:

 

Tab 1:

Tab 2:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from Jihwan_Kim , please allow me to provide another insight.
    Hi Anonymous ,

    Do you mean that after the slicer in Tab 1 selects the values, the slicer in Tab 2 automatically selects the corresponding values?

    If so, then it is impossible.

    A slicer can only filter other slicers and cannot control the selection of other slicers.

     

    Best Regards,
    Dengliang Li

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