Two Date Slicer to Slicer filter

DAX DAX Calculations
1

I have a two slicers one with Forecast date (will only have every week Monday date) and Date Range also same like Forecast Date.

image

how do I control the slicer output from one slicer to another slicer.

When some one selected the Forecast date value example 9/10/2023 in another slicer Date Range it should show only selected date range between 9/10/2023 to 11/12/2023. total 10 weeks of date

Please help me how to do it. I don’t have any data set its excel dashboard asked me to convert to Power BI

2

Hi @putturps ,

Welcome back to forum.

You can check Data Mentor answer to your question:

https://mentor.enterprisedna.co/account/documents/151

Hope you find it helpfull.

3

Sorry, I cannot open that link. Could you please repost it again?

Or share the solution in this window.

4

@putturps - sorry I forgot to make it public

Look at the second query in following thread:

https://mentor.enterprisedna.co/threads/slicer-synchronization-in-power-bi-46657

Hope it helps.

5

No luck yet, its taking to the below screen shot, but not showing an solution

image
image1190×648 10.6 KB

6

Answer:

Hi @putturps,

@mspanic - just add for your reference. it was giving the same error that @putturps was getting.

If you go into Data Mentor under Queries, you will be able to located that way too
here is the screen print

see highlight

image
image1631×911 205 KB

I hope this helps.
Keith

7

@putturps , @Keith thank you for your feedback.

I create new one - hope with better luck:

1 Like
8

Hi @mspanic,

The link worked fine.

thanks
Keith

1 Like