Forum Discussion

noyesae's avatar
noyesae
Regular Visitor
6 years ago

One Slicer for Multiple Data Points on Same Page

I'm trying to understand if you can have mutliple slicers on one page and when you update the dates on one of those slicers it changes the dates automatically on the other slicer.   The slicers are...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi noyesae ,

 

Based on your description, do you want to use a date slicer from an unrelated table to affect other date slicers in the same page?

If so,you can try to create a measure and apply it to the visual level filter of each slicer.

Try measure like this:

Measure = IF(MAX('Table'[date])in VALUES('Table 2'[date]),1,0)

 

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

noyesae's avatar
noyesae
Regular Visitor
6 years ago

I tried the formula but unforunately after creation I can't make it a Date format so it's not allowing me to put the Measure into the Slicer.

 

 

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi noyesae ,

     

    Apply this to the slicer's visual level filter.

    Sample .pbix

     

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

    • noyesae's avatar
      noyesae
      Regular Visitor
      6 years ago

      V-lianl-msft Thank you for continuing to look into this for me.  I'm pretty sure that I did everything you did but it's still not working for me.  When I put the measure into the filter area for the Date and the Visual all the data disappears.  Not sure why that is happening.  

       

      Also I noticed in what you sent me when you change the date in the Date slicer the Export dates change but the Import dates do not, did you intend for that to be the case.  I would need something that could change both slicers.