Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hey champs,
I need some advice how to solve this situation.
I  want to show average number of days a ticket stayed in a particular status. Values of this matrix i average of days / status
| jan | feb | mar | APRIL | MAY | JUNE | JULY | AUG | SEP | |
| STATUS1 | |||||||||
| STATUS2 | |||||||||
| STATUS 3 | 
Problem statement:
What if there are 10 issues and 9 issues took 30 days where as 1 issue took just 2 days. so average of this will be 3 days. What way i can show the variance too? 
i am using PBI desktop RS
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 5 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | 
| User | Count | 
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |