Good User Experience (UX) design is crucial in enabling stakeholders to maximise the insights that they are able to derive from Power BI reports. One common challenge of report design is effectively managing and displaying large datasets in bar charts without overwhelming the user. This article will describe the process behind a method that can mitigate this issue: adding pagination to bar chart visuals. This visual will provide the following functionality:
- A number of categories filter: users can specify how many categories they would like to see per bar chart page
- A page filter: users can navigate to different pages to see more categories
Click through to see how. I tend to prefer Power BI dashboards be glanceable, so pagination defeat that purpose to some extent. But so does having to scroll through a large list.