While Power BI does not have out-of-the-box components to support an interface with flexible navigation, you can still utilize Bookmark and Buttons to make your Power BI report become more interactive. This blog will show you how to use Button Component and Bookmark to create an interactive-KPI style dashboard within Power BI.

Step 1. Create bookmarks for different scenarios that you have. It is more efficient to create bookmarks now and bind them to your buttons’ action. You can always update them later!

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 2. Create a blank button as follow. This button will have the state of being unselected so give it a light background color. Here I have a gray background and gray text so that it won’t stand out too much.

Activate Action for this button and select ‘Bookmark’ option and connect it to the appropriate bookmark.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

For the button setting, turn off Background. Use Fill instead because this option let you choose different state of the button. Here we want a hover effect on the button to indicate a possibility of action. For default state, set Transparency at 50%, for Hover State, set it at 0%. You can play around with this option to create desired effects.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 3. Copy and Paste two more buttons, change the button texts and connect it to the corresponding Bookmark in Action option.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 4. Next, create the KPI Tiles that shows that data for corresponding KPI and put it on top of the buttons.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 5. Now is the time-consuming part! You need to create all the charts for all scenarios before Updating your bookmark! The tip is to always create a chart with the look and feel you want, then make a copy and just change the measure.

a) Create the Selected version of each button. Here I give it a blue background with white text to make it stand out. This button will not have any Action so turn this option off. Again, make a copy of this button for each scenario.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

b) Next, lay these buttons exactly on top of the unselected ones, you might also need to bring them to front.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 6. Create 3 different charts for 3 scenarios.

In this example, when analyzing Product Cost. I want to look at the Product Cost and Gross Revenue in Scatter Plot Chart

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

When analyzing Revenue, I want to analyze Revenue and Quantity Sold by Product Type.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

When analyzing Unit Price, I want to look at Unit Price, Unit Cost and Unit Sales Price by Retailer Country.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Step 7. Open Selection and Bookmark Panel and start updating your bookmarks. For each view, uncheck the Display icon to hide selected buttons and charts of other views. Then select the appropriate Bookmark and click Update.

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

KPI Tile Navigation in Power BI with Buttons and Bookmarks

 

Your navigation setting is done!

KPI Tile Navigation in Power BI
 

Subscribe to our Newsletter

5600 Tennyson Pkwy
Suite 120
Plano TX 75024.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com