Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pfandgiraffe
Regular Visitor

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 orders?

 

Actually i can see only the starting date cause my table with the prod. orders is linked with my date table and only one link can be activated at the same time.

 

Hope my explanation is comprehensible. Thanks in advance for any hint!

 

Pfandgiraffe_0-1701250227782.png

 

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @Pfandgiraffe ,

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

vjunyantmsft_0-1701656023952.pngvjunyantmsft_1-1701656052277.pngvjunyantmsft_2-1701656069788.png

The effect is shown below:

vjunyantmsft_3-1701656106645.pngvjunyantmsft_4-1701656259392.png


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.

View solution in original post

5 REPLIES 5
v-junyant-msft
Community Support
Community Support

Hi @Pfandgiraffe ,

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

vjunyantmsft_0-1701656023952.pngvjunyantmsft_1-1701656052277.pngvjunyantmsft_2-1701656069788.png

The effect is shown below:

vjunyantmsft_3-1701656106645.pngvjunyantmsft_4-1701656259392.png


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.

Hi @v-junyant-msft ,

 

thanks - that was what im looking for! 🙂 Thanks for this easy solution.

 

One little thing: Did you have an idea why the calendar week dissapear after using the Parameter?

Before:

Pfandgiraffe_0-1701686820261.png

After:

Pfandgiraffe_1-1701686859690.png

 

Pfandgiraffe_2-1701686969611.png

 

...When i remove and add the cw parameter again to the x-axis everything working well till i use the new parameter again.

 

 

 

kind regards!

 

Hi @Pfandgiraffe ,

Because there is a hierarchical relationship between calendar week and the start and end dates, the visual object applies drill-down functionality.
After switching, you only need to click this button to see the details:

vjunyantmsft_1-1701740023182.pngvjunyantmsft_2-1701740040334.png


Best Regards,
Dino Tao

 

Pfandgiraffe
Regular Visitor

Thanks for quick reply!

 

I have tested it but it won't work this way cause i cant put this meassure into my visual. (don't know why) The dax meassure itself looks okay cause it will work within a simple table chart visual. But not within a column chart.

 

I have build a simple test .pbix and a excel data table:

https://drive.google.com/drive/folders/1tMbJKSdsryf4cdam-n0MkY6-pdx6T4O8?usp=sharing

 

 

kind regards

isjoycewang
Super User
Super User

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]))

isjoycewang_0-1701251460273.png

 

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

 

Best Regards,

Joyce

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors