Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Situation: Im creating report for HelpDesk. Single user can create many tickets and single user can receive many tickets. I want to Slice report by how many tickets user created and how many tickets user created.
Problem: When I select user from slicer, it slices by tickets created by that user (this is according to relationship). But I want to also be able to slice by tickets he received to solve. How can I accomplish this?
Solved! Go to Solution.
@Vygintas , You need join all dates with a common date table. You will get one active and other inactive relationships. Inactive relationship can be activated using userelationship
refer similar
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
And files after signature
I ended up by creating two identical tables for tickets. And table "users" has two relationships to "tickets_for_agent" and "tickets_by_authors". Now when I select user, I get both how much tickets he created and how much he got to solve.
To create such table I used:
I ended up by creating two identical tables for tickets. And table "users" has two relationships to "tickets_for_agent" and "tickets_by_authors". Now when I select user, I get both how much tickets he created and how much he got to solve.
To create such table I used:
@Vygintas , You need join all dates with a common date table. You will get one active and other inactive relationships. Inactive relationship can be activated using userelationship
refer similar
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
And files after signature
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |