Forum Discussion

Pfandgiraffe's avatar
Pfandgiraffe
Frequent Visitor
2 years ago
Solved

Switch a visual between two different dates

Hi there,   i have a visual whitch shows me the starting date of manufacturing order. Is it possible to add a button (f.e. a data cut) to change between the starting date and the end date of these ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Pfandgiraffe ,

    You can create a parameter to be placed in the x-axis coordinates:

    The effect is shown below:


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

isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

Hi Pfandgiraffe,

 

You can try to create an inactive relationship between these 2 tables on EndDate.

And then you should be able to extract the end date by using USERELATIONSHIP() in your formula.

 

Please see below example.

EndDate = CALCULATE(MAX('Table'[EndDate]), USERELATIONSHIP('Date'[Date], 'Table'[EndDate]))

 

If it not fits in your case, please share more dummy data and your expected results. 

 

Best Regards,

Joyce