When you work with buttons in Power BI, for example to work with bookmarks, it is useful to see which “view” is active in your report. It is a bit like the idea of web navigation. When you show the active bookmark on the button, the report is a lot nicer to look at.
Below I show an example of what I mean.
Basically, I put two buttons without formatting over the chart. When you click “alle”, you want this button to look different from “Vervuld”. But when you are on “vervuld”, you want that button to look different. How do you handle this?
At the moment Power BI does not let you use bold formatting in buttons. Pinning a bookmark also does not work well with formatting. The trick is to make four buttons, two of each. Then you put them on top of each other and create two bookmarks, where you turn two buttons off and two on. Then, under “text”, you set font-family to “Segoe UI Bold”, which makes the font bold.
Frequently asked questions
Can I make a button bold in Power BI when it is active?
Not directly. Power BI has no bold formatting in buttons, and pinning a bookmark does not work well with formatting. You can solve this with four buttons and two bookmarks.
How do I show which bookmark is active in Power BI?
Make four buttons, two per view. Put them on top of each other and make two bookmarks, each with two buttons on and two off. The button with bold text shows the active view.
Which font makes the text bold in a Power BI button?
Under Text, set font-family to Segoe UI Bold. This makes the button text bold, even though Power BI has no separate bold setting for buttons.
Why does a Power BI bookmark not work well with button formatting?
Pinning a bookmark does not work well with formatting. So you do not switch the formatting. Instead, you turn buttons on or off per bookmark.
How many buttons do I need for an active button with bookmarks in Power BI?
Four buttons, two of each. You put them on top of each other. Two bookmarks each turn two of the four buttons on and two off.
Comments
Related blogs
Postcode Tables in Databases and Power BI: Linking Geographic Information to Business Performance
Making Sense of Time: An Introduction to SQL Server's DateTime Functions
From Excel to Power BI: Transitioning to Advanced Analytics