Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello all,
Could someone please help with the following issue that I have?
I have dataset which collect data from next process:
Manager_start started process with unique uuid (job_id not unique, because if status don't change to 'finish_pass' it's not close. After Manager_start finished (close) his job - it's automatically assigned on Manager_finish. If status 'finish_decline' - Manager_finish field stay 'blanc'
I need prepare visualization (table and bar chart) example
which will show amount of processes by manager_finish amount. It should look same like this. (Fortable it should be grouped by Number of processes and for chart on X axis should be amount of processes and for Y axis should be amount of Managers who finished process.
Also should be able to filter visualizations by next filters: uuid, job_id, status, date_finish_working, manager_name_start, manager_name_finish
I have dataset in table with such columns:
- uuid (uuid of process) identifier
- job_id (id of job which need to be done))
- status - status of process (everytime begins from 'start' and could finish with 'finish_pass' or 'finish_decline')
- date_start_working - date when job start get in work
- date_finish_working - date when process finished
- manager_id_start - id of manager, who start process
- manage_name_start - name of manager, who start process
- manager_id_finish - id of manager, to whom processed assigned
- manager_name_finish - name of finish manager
I found same case with solution (https://community.powerbi.com/t5/DAX-Commands-and-Tips/distribution-of-calculated-measure/m-p/104778...), but it's not working to my case, because I need to have ability filtering data by different fields and have diffent data structure
Final result should be like this (based on dataset - link bellow) + ability to filter visualizations by next parameters: uuid, job_id, status, date_finish_working, manager_name_start, manager_name_finish
Data sample example available by link (upload it to file storage)
https://mir.cr/1WUOZTON
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
78 | |
52 | |
39 | |
35 |
User | Count |
---|---|
94 | |
79 | |
51 | |
47 | |
47 |