Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I have the below data which contains reported IT incidents of certain issue types at a local company. The request is to show the standard deviation on a monthly basis for the overall volume and per category as well while showing the average of volume and the max/min of the deviation.
What are the measures that I'd need to create this and what kind of visuals would you recommend for it?
Thank you in advance!
Case no | Date of incident | Category | Region |
100001 | 1/4/2021 | HW | EMEA |
100002 | 1/5/2021 | MDM | AMER |
100003 | 1/6/2021 | Exchange | AMER |
100004 | 1/7/2021 | MDM | AMER |
100005 | 1/8/2021 | Exchange | EMEA |
100006 | 1/9/2021 | PW | APAC |
100007 | 1/10/2021 | PW | APAC |
100008 | 1/11/2021 | CRM | APAC |
100009 | 1/12/2021 | CRM | AMER |
100010 | 1/13/2021 | HW | AMER |
100011 | 1/14/2021 | MDM | AMER |
100012 | 1/15/2021 | Exchange | EMEA |
Hello @amitchandak , thank you for the linked videos. How would you go about the differences in the dataset? In the linked video (second one) each line contains the value (distance run/covered by a specific player on a given day summed up) on which the calculation is performed. However in my dataset, each line will only have the value of 1 as the incidents are all counted separately line by line. Thank you!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 45 | |
| 35 | |
| 34 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 122 | |
| 100 | |
| 80 | |
| 57 |