Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi there,
After nearly two years of not touching Power BI at work, I finally returned to a position where I need to use it. Having said that I would appreciate it if you can help me with the following problem:
I am given a dataset with the log of activities in a tech support department. The log contains all the activities logged in an incident in a range of dates (last 6 weeks). Each activity contains a unique Incident #, but the incidents can have multiple lines of activities in the file.
The problem: I need to track and report on each incident that has been elevated from one level of support to another (tier to tier), but I have no idea how to identify (via DAX or Data modeling) the specific line per incident where the tier changes so that I can calculate and visualize the data. Would you be so kind to help me with this, please?
As you can see in the screenshot there are instances in which the incident gets escalated from one tier to another, please keep in mind that the file contains 20K+ lines.
Escalation from tier to tier example
overall look of the log
Thank you beforehand for the help, if you need me to send more information or files, please let me know.
Jorge.
Solved! Go to Solution.
Hi @GReyes85,
Perhaps you can do these in query editor, group raw table category fields and use add index function to add index for the current group:
Create Row Number for Each Group in Power BI using Power Query
Regards,
Xiaoxin Sheng
Hi @GReyes85,
Did these suggestions help for your scenario? If that is the case, you can consider Kudo or accept the suitable one to help other users who faced the same issue to find it more quickly.
If the above not help, you can feel free to post here with some detailed information.
Regards,
Xiaoxin Sheng
Hi @GReyes85,
Did these suggestions help for your scenario? If that is the case, you can consider Kudo or accept the suitable one to help other users who faced the same issue to find it more quickly.
If the above not help, you can feel free to post here with some detailed information.
Regards,
Xiaoxin Sheng
Hi @GReyes85,
Perhaps you can do these in query editor, group raw table category fields and use add index function to add index for the current group:
Create Row Number for Each Group in Power BI using Power Query
Regards,
Xiaoxin Sheng
You have the Activity Date column - that can serve as the index (unless you have unfortunate scenarios where two changes have the same timestamp - hopefully not). So you can use that column to sort your incidence information and find out the order of escalations/deescalations.
Ibendlin,
Thanks for the suggestion, but that is the case: several incidents may have the exact same time-stamp as the incidents are worked by a large group of tech support analysts
In that case you are doomed - unless you have a GUID generator in your ticketing process.
@GReyes85can you provide a sample data representative of your issue?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
56 | |
37 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |