top of page
9d657493-a904-48e4-b46b-e08acb544ddf.png

POSTS

7 Overlooked Native Power BI UI Features—and How to Use Them

Writer: MirVel
MirVel
4 minutes ago
7 min read

Introduction


Your report can have accurate numbers and still be awkward to use. A filter panel resets someone’s choices, a chart click changes an unrelated KPI, or every page asks for the same country selection again. These are often interface problems you can solve with native Power BI controls.


This guide implements seven useful Power BI native UI features in one small sales report. “Overlooked” is an editorial selection, not a measured popularity ranking. You’ll learn what to configure, why it helps, and how to check the result.


Why this matters


Imagine a monthly review with Finance and Operations. Finance wants the same country selection on every page. Operations wants to switch the chart’s grouping. Both need to understand what a click will change.


A useful interface makes those choices predictable. Start with the behavior you want, then choose the native control. A bookmark suits visibility changes; a field parameter suits changing the field inside a chart. They solve different jobs.


Before you start


Use a current Power BI Desktop build and a copy of your report. The paths below use English Desktop labels; ribbon and pane layouts can differ by version and authoring experience. Service editing requires report edit permissions, and normal sharing and licensing rules still apply.


For this exercise, use Home > Enter data to create a table called Sales with the six illustrative rows below. Set Revenue and Cost to numeric types. Create two pages called Summary and Details. No external tools or custom visuals are needed.


Country

Channel

Revenue

Cost

DE

Online

12000

8000

DE

Partner

8000

5000

AT

Online

6000

4000

AT

Partner

4000

2500

CH

Online

10000

6500

CH

Partner

5000

3000


These are invented teaching values, not customer results. On Summary, add a Country slicer, a column chart with Channel on its axis and Sum of Revenue as its value, and a card showing Sum of Revenue. On Details, add a table with all four columns and a Country slicer if you want it visible there.


Step-by-step: implement seven native UI features


1. Use selected-visual bookmarks for a collapsible filter panel


The useful detail is a bookmark’s scope. For an open/close panel, save visibility without restoring old slicer choices.


  1. Open View > Selection and View > Bookmarks. Add a panel background and a Close filters button beside the Country slicer. Rename these objects so they’re easy to select.

  2. Leave a separate Open filters button visible. Select the background, slicer and close button. With those three visible, add Filters — Open. In its menu, turn Data off, Display on and Current page off; choose Selected visuals, then Update.

  3. Hide the same three objects in Selection. Select them through the pane and create Filters — Closed with the same options. Update it.

  4. For each button, enable Action, choose Bookmark and assign the matching open or closed bookmark. In Desktop editing, Ctrl+click to test.


Expected result: select DE, close the panel and reopen it. DE should remain selected. Hiding a slicer does not stop it filtering the page. Bookmarks restore visibility here, not animated movement.


Reconstructed bookmark options showing Data off, Display on and Selected visuals for the Country filter panel.
Reconstructed illustration — select the panel objects and save Display without Data, so opening or closing the filter panel preserves the current country selection.

2. Add a page navigator that follows page names


Hand-building one button for every page creates more objects to maintain. A native page navigator follows report page names and ordering.


  1. Choose Insert > Buttons > Navigator > Page navigator.

  2. Use the navigator’s formatting settings to arrange its buttons horizontally, vertically or in a grid.

  3. Give the Selected state a distinct fill and readable text. Under Pages, review whether hidden and tooltip pages should appear.

  4. Rename Details temporarily and check that the button label follows. Restore the name, then Ctrl+click the navigator in Desktop.


Use a bookmark navigator when readers need saved views instead of pages. Restrict it to the intended bookmark group. Its selected styling reflects the last selected bookmark; don’t treat that styling as a complete description of every active filter.


3. Separate Sync from Visible in synced slicers


A selection can apply to another page without displaying the slicer there. Those are two separate decisions.


  1. Select the Country slicer on Summary and open View > Sync slicers.

  2. Enable Sync for Summary and Details.

  3. Enable Visible on both pages for the clearest beginner experience. Alternatively, leave Details invisible when you deliberately want a cleaner canvas.

  4. Select DE on Summary, navigate to Details and check the rows. Only the DE rows should remain.


If you hide the slicer on Details, give readers another clear way to understand or change the active country. When a page looks unexpectedly filtered, inspect Sync slicers as well as the Filters pane. A hidden control can still explain the result.


Reconstructed Sync slicers pane with Summary synced and visible, Details synced but hidden, and Notes unsynced.
Reconstructed illustration — Details has Sync enabled and Visible disabled: the Country selection still filters that page even though its slicer is not displayed.

4. Choose which chart clicks affect each visual


Visual interactions are directional: you select a source visual, then configure what its selection does to each target.


  1. Select the Channel column chart and choose Format > Edit interactions.

  2. Above the revenue card, select None so chart clicks leave that card unchanged.

  3. For another chart, choose Filter or Highlight where that target supports the option. Use the behavior that matches the comparison you want.

  4. Exit Edit interactions and select Online in the source chart. Check every target, then clear the selection.


Label the card to explain its role, for example Revenue — current country. It should ignore the Channel chart selection but still respond to Country. None removes this source-to-target interaction; it does not remove page filters, report filters or security rules.


5. Add Apply all slicers and Clear all slicers deliberately


When people choose several slicers before reading the result, applying the choices together can avoid intermediate visual queries. The saving depends on the report; no timing improvement is claimed here.


  1. Choose Insert > Buttons > Apply all slicers.

  2. Add Clear all slicers from the same menu.

  3. Change several selections, then activate Apply all slicers. Check that the visuals reflect the applied choices.

  4. Use Clear all slicers and confirm the page’s slicer selections are cleared.


Clear all slicers clears slicers on the page; it is not a full report reset or a saved default selection. If you need a named starting view, design a separate data bookmark for that purpose.


Important with Step 1: when the last Apply all slicers button on a page is hidden, slicers return to instant application. Keep it outside the collapsible group if you want deferred application to remain available. Test pending selections and synced pages together before sharing.


6. Switch a chart’s axis with a field parameter


A field parameter lets readers choose the column used to group a visual. That avoids maintaining a separate chart for every breakdown.


  1. Choose Modeling > New parameter > Fields. Name it Analyze by.

  2. Add Sales[Country] and Sales[Channel], keep Add slicer to this page enabled, and create the parameter.

  3. Replace the column chart’s existing axis field with Analyze by. Leave Sum of Revenue in its value field.

  4. Use the parameter slicer to switch Country and Channel. Enable single selection if the design should show one breakdown at a time.


Expected result: the chart groups the same revenue by the selected dimension. Country is a grouping field here, not a revenue measure. For measure parameters, use explicit DAX measures; implicit aggregations are unsupported. A pure live connection needs a local model before you can create field parameters. Clearing the parameter selection means all fields, not an empty chart.


Reconstructed field parameter dialog named Analyze by with Country and Channel selected and Add slicer to this page enabled.
Reconstructed illustration — create Analyze by from Country and Channel, then place the parameter on the chart axis so readers can switch the grouping.

7. Set keyboard tab order and useful alt text


A report’s visual layout and its keyboard order can tell different stories. Native accessibility settings let you align them.


  1. Open View > Selection and select Tab order.

  2. Move the meaningful controls into a logical sequence: navigation, Open filters, slicer and Close filters when shown, parameter selector, charts and card.

  3. Remove decorative backgrounds and shapes from the tab order.

  4. For meaningful visuals, open Format > General and add alt text. Describe what the visual shows or does, rather than repeating its title.


Test with the keyboard in the published report’s reading experience, including both panel states. Check that readers can reach and operate the controls. Static alt text should not hard-code a number that changes when the data refreshes. Keep visible labels clear and don’t rely only on color to explain selection.


Practical example: run one complete review


Start with all countries and no chart selection. The six rows total 45,000 revenue and 29,000 cost; these arithmetic checks provide a baseline for the sample. Use one currency consistently if you format the numbers as money.


  1. Open the panel, select DE and apply the choice if deferred filtering is enabled. Revenue should be 20,000 and cost 13,000.

  2. Close and reopen the panel. DE should stay selected.

  3. Navigate to Details. The table should show the two DE rows.

  4. Return to Summary and select Channel in Analyze by. The DE bars should show Online 12,000 and Partner 8,000.

  5. Select Online in the chart. The card configured with None for that chart should remain at 20,000.


Record a pass or failure for each action. If a result differs, first clear chart selections and inspect slicers and Filters. Then check bookmark scope and the source-to-target interaction. This sequence is an acceptance checklist, not a claim that a PBIX was executed for this article.


Bonus tips and common mistakes


Pro tip: write down which objects each bookmark owns. Keep visibility bookmarks separate from intentional data-reset bookmarks. Update them when you add or replace controls.


Common mistake: combining every feature immediately. First make the country selection reliable; then add navigation, optional grouping and deferred application. Each extra control should answer a reader’s real question.


Good to know: visibility is presentation, not access control. Hiding a visual or page does not secure its data. Keep your existing permission and row-level security design, and validate the report with its intended audience.


The three instructional images are simplified reconstructed illustrations based on the linked documentation. They show the settings to inspect, not authentic Desktop captures. The implementation was checked against documentation and sample arithmetic, but was not executed in Power BI Desktop here.


Final thoughts


Start with one frustrating interaction in an existing report. Implement the matching native option, verify the expected result and ask a colleague to use it without coaching. A clear interface gives readers confidence about what their clicks changed—and gives the next report author a setup they can understand.


Sources and further reading


Microsoft Learn documents the supported behavior below. The practitioner walkthroughs provide useful explanations; older screenshots and preview instructions should not be treated as current availability guidance.











Continue on Excelized:




Want hands-on help building clearer Power BI reports? Explore Excelized’s Power BI training.



Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
Excelized logo

Turn Messy Data into Clear Dashboards and Better Decisions.

Explore

Contact

Address:
83022 Rosenheim, Germany

Join Our Newsletter

Get a free Power Query cheat sheet by subscribing!

© Excelized. All rights reserved.

bottom of page