What is the difference between drill down and drillthrough?
Drill down moves through a hierarchy inside the same visual: from year to quarter to month, or category to product. Drillthrough jumps to another page filtered on what you right clicked: from a product in a bar chart to a Product details page. To set it up, add the field to the target page's drillthrough well; Power BI adds a back button.
How do you stop one visual from filtering another?
Select the visual that does the filtering, open Format, then Edit interactions, and on each other visual choose filter, highlight or none. A KPI card that must always show the company total, for example, is set to none for the category chart. The setting is per pair of visuals on a page.
What are bookmarks used for?
A bookmark saves the state of a page: filters, slicers, sort order, drill level and which visuals are visible (from the Selection pane). With buttons it builds a toggle between a chart and a table, a show and hide filter panel, a reset to defaults button, or a guided story. Each bookmark can store data, display or the current page, so choose what it should restore.
How do you build a report page tooltip?
Make a new page, set its canvas size to Tooltip and turn on Allow use as tooltip in its page information, then build small visuals on it. On the main visual, set the tooltip type to Report page and pick that page. When readers hover a bar, the tooltip page shows filtered to that bar, for example a trend line for the hovered product.
How do you apply conditional formatting based on a measure?
Background color, font color, data bars and icons can follow rules, a gradient, or a field value. For full control, write a measure that returns a color and choose Format style: Field value:
Growth Color = IF ( [Sales YoY %] < 0, "#D64550", "#1A7F5A" )The same measure can color a card's value or a chart's bars, so one rule colors the whole page.
How do you make a slicer apply to several pages?
Open View, then Sync slicers, and tick the pages where the slicer should filter (sync) and where it should appear (visible). A slicer can filter a page without being shown on it. Slicers in the same sync group share their selection even when they are separate visuals.
What are field parameters?
A field parameter lets readers choose which measure or column a visual shows, from a slicer: Sales, Profit or Units on one chart, or the chart's axis by Category, Region or Month. Create it under Modeling, New parameter, Fields; Power BI builds a small table listing the fields and adds a slicer. It replaces several near identical visuals switched with bookmarks.
How do you make a chart title change with the slicer selection?
Write a text measure and bind the title to it with the fx button under Title, Text:
Chart Title = "Sales by month for " & SELECTEDVALUE ( Product[Category], "all categories" )SELECTEDVALUEreturns the category when exactly one is selected and the alternate text otherwise. For several selections,CONCATENATEX ( VALUES ( Product[Category] ), Product[Category], ", " )lists them.How do you show the top N products, with N chosen by the reader?
For a fixed N, use the Top N filter type on the visual in the Filters pane. For a reader chosen N, create a numeric what-if parameter (here a table
'Top N'with a column[Top N]) and a measure that hides the rest:Top N Sales = VAR N = SELECTEDVALUE ( 'Top N'[Top N], 5 ) RETURN IF ( RANKX ( ALLSELECTED ( Product[Product] ), [Total Sales] ) <= N, [Total Sales] )Products ranked below N return blank and disappear from the visual.
What makes a Power BI report easy to read?
One question per page, the key numbers in cards at the top left where reading starts, then the breakdowns. Few visuals per page, sorted bars instead of pies, consistent colors (one meaning per color, set in a theme), clear titles that state what the visual shows, and labels instead of legends where possible. For accessibility: enough contrast, alt text on visuals and a sensible tab order.
What should you check before using a custom visual from AppSource?
Whether it is certified (Microsoft has reviewed that it does not access external services), whether your organization allows it (admins can restrict visuals to an approved list), how it performs with your data volume, and whether it supports export, high contrast and the mobile layout. Uncertified visuals can be blocked in some exports and embeds, so prefer a built in visual when one does the job.
Power BI Report and Visualization Interview Questions
Drill down and drillthrough, interactions, bookmarks, tooltips, conditional formatting, parameters and readable report design.