I have a table of trouble tickets that I’m displaying. A trouble ticket has many different dates associated with it, such as Date Created, Troubleshooting Started, Issue Resolved, Date Closed, etc. I’m looking to give the end user the ability to filter a table displayed on a page based off the date type chosen. A user may want to see
TTs that were closed in February which may include some that were created in January
What TTs were “Issue Resolved” in February.
Or as simple as displaying the TTs that were created in February
What I am hoping for is an additional slicer on my page where the user can choose which date field they want to see. (I’ve included what I was thinking in my attached file). And the ultimate would be to add cards that would calculate counts of the TT’s based off the Date selected but I have to overcome this first issue before I can start with the metrics.
I’ve gone through as many videos that I can find that use TREATAS or USERELATIONSHIP but that is for calculating values. I need to display data properly based off the date type chosen then I can do my calculations.
Is this even possible in Power BI without having to duplicate data and enlarging my data model by as many fields I’m wanting to filter? Hopefully its simple and I just missed a video on how to do it.
I’ve read through that article before and its very useful for calculating values and filtering those values by inactive date relationships, but it doesn’t show how you can just display data based off different dates. Or at least I’m still not seeing how I can do it using a measure.
I’ve seen the technique with creating a date table for each column you want filtered but the only way that I could get that to work is to have a slicer for every date I want filtered.
I want the ability to choose what date field the table is filtered by. But once that choice is made then I will create a measure to count the rows within that context.
You could create bookmarks & buttons which will display the selected date filter and then hide the others so you would only have one date slicer on show at a time?
Hello @Durnin it’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
We’re aware of the issue and have already been investigating it. Our team is actively working on a resolution, and we’ll update you as soon as it’s fixed.
We appreciate your patience, and please let us know if you need anything else in the meantime.