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
I am building a report using the Power BI API connector to gather usage information.
I would like to measure what I would call the consistency of use.
For instance, given the views of two report over a 12 day period, one with a view each day and the second with 6 views on day one and 6 views on day 12, I would like to demostrate that the first shows more consistant use than the second.
Report 1 | Report 2 | |
| d1 | 1 | 6 |
| d2 | 1 | |
| d3 | 1 | |
| d4 | 1 | |
| d5 | 1 | |
| d6 | 1 | |
| d7 | 1 | |
| d8 | 1 | |
| d9 | 1 | |
| d10 | 1 | |
| d11 | 1 | |
| d12 | 1 | 6 |
| Avg | 1 | 6 |
The Average returns 1 for the first period and 6 for the second period. But that is misleading. The second period clearly had less activity throughout the period. I would want to be able to show that Report 1 shows more consistant use.
What statistical measurement would be used to describe the consistancy of activity over a period of time? How would I implement this in Power Bi?
Thx
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 46 |