March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi!
I have a list of tickets with their creation date ("Short Date_Created", date format), some of the tickets were completed, so these also have a completion date ("Short Date_Completed", date format).
Both dates are linked to a general date table (TimeTable); The active relationship is between created date and the general date, the inactive is for the completion date (I marked them on the picture).
I'm trying to analyze the data, as a start - created vs. completed tickets.
The count was simple, as I used calculate function with count and userelationship (two measures, one per created and one per completed, with the relevant relationship). But I also need to show what was created and what was completed in the date range.
The date range is a slicer that is taken from the TimeTable, and as I can see good results for the created tickets (comparing these to the raw data that I have), I cannot find a way to present the completed tickets list (assuming it's because of the inactive relationship).
For example: I see 15 created tickets on Feb with the correct list of tickets. 12 tickets were completed on Feb, but the list doesn't filter them correctly, it just shows the created issues.
So my question is - how can I show them on a table? I want to present the "12" that pbi was able the count 😅 thanks!
Solved! Go to Solution.
I managed to solve it! so writing it here if anyone encounters this issue:
1. The graph is relevant for the TimeTable date (that's the general date that has relations with created and completed dates)
2. The table visual for created items is filtered by created date slicer
3. The table visual for completed items is filtered by completed date slicer
4. All slicers don't impact the other visuals
5. All slicers are synced, using this method: https://www.youtube.com/watch?v=CqPE6__sulg
6. Only the TimeTable date (general date) remains visible, other dates (created and completed) are invisible
The result is that we change just the TimeTable date, that impacts the other dates. Visuals (tables or graph) change according to their active slicer.
I managed to solve it! so writing it here if anyone encounters this issue:
1. The graph is relevant for the TimeTable date (that's the general date that has relations with created and completed dates)
2. The table visual for created items is filtered by created date slicer
3. The table visual for completed items is filtered by completed date slicer
4. All slicers don't impact the other visuals
5. All slicers are synced, using this method: https://www.youtube.com/watch?v=CqPE6__sulg
6. Only the TimeTable date (general date) remains visible, other dates (created and completed) are invisible
The result is that we change just the TimeTable date, that impacts the other dates. Visuals (tables or graph) change according to their active slicer.
You may want to clean up the relationships between your tables. Ideally should be 1:* from Dimension -> Fact.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
132 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |