Power BI UI/UX Optimization for Product Performance Dashboard
Improved a Power BI dashboard’s UI/UX with bookmark navigation, dynamic filters, and custom DAX insights.
At a glance
-
A product performance dashboard showed every filter and slicer at once and split comparisons across several pages.
-
Users still needed full filtering and year-on-year KPI comparison — the redesign could not remove capability.
-
Single-page navigation built with bookmarks, a toggleable filter pane, and a custom DAX measure that prints the active filters on the canvas.
-
Less clutter, faster movement between views, and active filters visible without opening the pane.
Overview
Business intelligence dashboards often contain powerful insights but suffer from poor usability due to cluttered layouts and complex navigation. When too many filters, slicers, and visuals are displayed at once, users often struggle to focus on the most important metrics.
In this project, I improved an existing Power BI product performance dashboard by redesigning the UI/UX, optimizing navigation, and enhancing filter visibility. The goal was to help users easily compare product KPIs against the previous financial year while maintaining a clean and intuitive interface.
Problem
The original dashboard presented several usability challenges:
- Too many filters and slicers always visible, causing visual clutter
- Users needed to navigate across multiple pages to compare visualizations
- Difficulty identifying which filters were currently applied
- The interface distracted users from key product performance insights
As a result, users spent more time navigating the dashboard rather than analyzing the data.
Solution
I redesigned the dashboard experience by implementing interactive UI elements, streamlined navigation, and dynamic filter visibility.
The improvements focused on three main areas:
- Simplifying dashboard navigation
- Improving UI/UX design
- Increasing transparency of applied filters
Key Features
1. Single-Page Navigation Using Bookmarks
I used Power BI Bookmarks to build a single-page navigation system that allows users to switch between multiple visualizations without leaving the page.
Benefits:
- Quickly compare different product KPIs
- View multiple analytical perspectives
- Navigate insights without switching dashboard pages
2. Hidden Filter Pane for a Cleaner Interface
To reduce visual clutter, I designed a toggleable filter pane using bookmarks and buttons.
Features:
- Filter panel remains hidden by default
- Users can click a filter button to reveal the filters
- Focus remains on data visualizations instead of filters
This significantly improved the clarity and usability of the dashboard.
3. Applied Filter Indicator Using Custom DAX
Users previously needed to repeatedly open the filter pane to verify active filters.
To solve this, I wrote a custom DAX measure that dynamically identifies and displays the currently applied filters directly on the dashboard.
Benefits:
- Users can instantly see active filters
- Eliminates the need to frequently toggle the filter pane
- Maintains analysis context while interacting with visuals
4. KPI Comparison Across Financial Years
The dashboard enables users to compare:
- Product performance
- Key KPIs
- Trends between the current financial year and the previous financial year
This allows stakeholders to quickly identify growth trends, declines, and performance gaps.
Technologies & Tools
- Power BI – Dashboard design and visualization
- DAX (Data Analysis Expressions) – Custom logic for filter detection
- Power BI Bookmarks & Buttons – UI navigation and interactivity
Impact
The redesigned dashboard significantly improved the user experience and efficiency of data analysis.
Key outcomes:
- Reduced visual clutter and improved dashboard readability
- Faster navigation between insights using single-page bookmark navigation
- Improved visibility of active filters
- Easier comparison of product KPIs across financial years
These improvements allowed users to focus more on insights and decision-making rather than navigating the dashboard.
Key Skills Demonstrated
- Power BI Dashboard UI/UX Design
- Advanced Bookmark Navigation
- Custom DAX Development
- Data Visualization Optimization
- User-Centered Dashboard Design