Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Question on a Statistical Measure - Consistency of Usage

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

d116
d21 
d31 
d41 
d51 
d61 
d71 
d81 
d91 
d101 
d111 
d1216
   
Avg16

 

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

1 REPLY 1
rsbin
Super User
Super User

@Anonymous ,

Have attached a pbix that will give you a couple of ideas.

Main point is to Count the Days viewed rather than a sum of actual views.

Have created a Multi-row Card Visual and a Column Chart....just ideas to help get you started.

Regards,

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.