Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
70 | |
43 | |
31 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |