Forum Discussion
How to select data for a certain period, based on a table with 2 dropdowns "StartDate" and "EndDate"
- 1 year ago
Thankyou, ToddChitt, for your response.
Hi Lidi,We appreciate your question on the Microsoft Fabric Community Forum.
Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:
We hope the information provided helps to resolve the issue.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.Thank you.
Good day Lidi,
I'm coming to this quite late and you've probably solved the problem. However, here goes...Let's say your data looks something like this - a performance rating is recorded for each employee, together with a date for that rating.
If this is how your data looks then you could use a slicer visual on "Date", setting the slicer style to "Between".
Which would look like this,
Giving an overall look,
Hope this helps