Forum Discussion
Time Difference based on Slicer
Hello,
I have the following data.
I want to have the time between the Start Date and the End Date.
The problem is the following: I want to use a slicer to determine the time period and only days that are in the time period should be included. For example choosing May should show different times than choosing April on the slicer.
How can this be implemented?
Thank you and kind regards
2 Replies
Hi Klausi500 ,
What kind of slicer do you want to create? How is the time period selected for this slicer used, can you give a simple example?
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
here is my exaple file:
https://wetransfer.com/downloads/fa44395c304cdd5209c55f9f4a3d78c620230621110100/1f1bf336679cb901a81b96f0233305db20230621110118/ce38df
In the current example I see the working days between the start and end Timespamp. I need the days split into whatever period I chose on the slicer (month, years).
If it is not possible to handle dynamic, I would like to have it at least monthwise.
Is it clear now?
Thank you and kind regards
Tobias
