Microsoft Power BI Quiz: Visual Formatting

10 questions · exam conditions

0:00

Visual FormattingQuestion 1 of 10

You import a corporate report theme into an existing Power BI report. Newly created visuals use the corporate title font and color palette, but several existing visuals retain manually assigned title fonts and data colors. You must apply the theme defaults to those visuals without changing their fields, filters, or interactions.

What should you do?

Reimport the corporate theme after deleting the report's persistent filters.

Select the affected visuals and reset their formatting to the theme defaults.

Duplicate each affected visual and replace its fields with the original fields.

Apply the theme and then refresh the semantic model and report visuals.

← Back to quizzes

Microsoft Power BI Quiz

Microsoft Power BI Quiz: Visual Formatting

Practice Visual Formatting in Microsoft Power BI with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Visual Formatting, giving you a quick way to practice the rules, question types, and explanations that matter most for Microsoft Power BI.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

What should you do?

Reimport the corporate theme after deleting the report's persistent filters.
Select the affected visuals and reset their formatting to the theme defaults. (correct answer)
Duplicate each affected visual and replace its fields with the original fields.
Apply the theme and then refresh the semantic model and report visuals.

Explanation: When working with Power BI themes, it's important to understand the difference between theme defaults and manual overrides. Importing a theme sets new defaults for the report, but any formatting you've explicitly set on a visual — like a custom font or specific data color — becomes a manual override that intentionally persists even after a theme change. This is by design: Power BI respects your deliberate customizations. The correct approach is B: select the affected visuals and use the "Reset to default" option within the Format pane. This clears the manual overrides on those specific visuals and lets the theme's defaults take over — without touching fields, filters, or interactions. It's a targeted, non-destructive fix that's built exactly for this scenario. A is a red herring. Persistent filters have nothing to do with visual formatting or theme application. Deleting them would remove filter state from the report, which is unnecessary and potentially harmful to the report's intended behavior. C describes an unnecessarily complex workaround. Duplicating visuals and reassigning fields replicates the structure but doesn't inherently remove manual overrides — and it risks disrupting interactions and introducing errors in field mapping. D confuses data refresh with formatting. Refreshing the semantic model updates the underlying data, not visual formatting properties. Theme application and data refresh are completely separate processes in Power BI. As a study tip, remember that in Power BI, theme import affects defaults, while manual overrides always win until explicitly reset. On exam questions involving theme conflicts, look for the answer that resets formatting at the visual level — that's your signal for option B-style answers.

Question 2

A report contains a slicer for fiscal year. A chart title must display "Revenue — FY2026" when one year is selected and "Revenue — Multiple years" when zero or multiple years are selected. The title must update automatically when the slicer selection changes.

Which configuration should you use?

Create a DAX measure that returns the required text, and bind the title text to the measure by using conditional formatting. (correct answer)
Create a calculated column containing a title for each year, and add the column to the chart's tooltip field well.
Enter a static chart title, and enable the slicer's visual interaction with the chart so the year is appended automatically.
Create a bookmark for each fiscal year, and configure the slicer to activate the corresponding bookmark title.

Explanation: When a Power BI question asks about dynamic visual titles that respond to slicer selections, you should immediately think about DAX measures combined with conditional formatting — this is the standard pattern for any context-aware visual property. A DAX measure can evaluate the current filter context using functions like SELECTEDVALUE() or HASONEVALUE() to detect whether exactly one fiscal year is selected. The measure returns the appropriate string — "Revenue — FY2026" or "Revenue — Multiple years" — and you bind it to the chart's title through conditional formatting on the Title field (Format pane → Title → fx button). Every time the slicer changes, the filter context updates, the measure recalculates, and the title refreshes automatically. This makes A the correct answer. B fails because calculated columns are computed at data refresh time and exist in row context, not filter context — they cannot respond dynamically to slicer selections. Adding one to a tooltip field doesn't produce a chart title at all. C is a trap: Power BI does not have a built-in feature that automatically appends slicer values to a static chart title. Visual interactions control filtering behavior, not title text composition. D misunderstands bookmarks. Bookmarks capture a snapshot of the report state, and while you can use them for navigation, they don't dynamically generate titles based on slicer selections — you'd need a separate bookmark for every possible selection, which is unscalable and doesn't handle zero-selection or multi-selection gracefully. Study tip: Whenever you see "title must update automatically," think DAX measure + conditional formatting on the title property — this pattern appears frequently on the Power BI exam.

Question 3

A corporate theme defines positive values as blue and negative values as red. After the theme is imported, one bar chart continues to show positive values in orange. The chart has a data-color conditional-formatting rule that was created before the theme was imported.

How should you make the chart use the theme's standard colors?

Remove the chart's conditional color rule and reset its data colors to the current theme defaults. (correct answer)
Move the chart behind another visual and then reapply the corporate report theme.
Change the measure's model format string so positive values inherit the theme's blue color.
Disable chart interactions and refresh the page so the theme takes precedence over the rule.

Explanation: When working with Power BI themes and visual formatting, it's essential to understand the formatting priority hierarchy: explicit conditional formatting rules always override theme defaults. Themes set baseline colors, but any manual or conditional formatting applied directly to a visual takes precedence — even after a new theme is imported. This is exactly the trap in this scenario. The bar chart still shows orange because a conditional formatting rule was applied to its data colors before the theme arrived. Importing the corporate theme doesn't automatically remove that rule — it simply sits beneath it in the priority stack. To let the theme's blue/red convention take effect, you need to do two things: delete the conditional color rule and then reset the data colors back to the current theme defaults. That's precisely what A describes, making it the correct answer. B is a distractor built on the false idea that visual layering or z-order affects theme inheritance — it doesn't. Stacking visuals has no bearing on formatting rules. C mistakes a model format string (which controls how numbers are displayed as text) for a color-formatting mechanism — format strings can't assign theme colors to chart bars. D suggests that disabling interactions and refreshing the page forces theme precedence, but neither action removes an explicit conditional formatting rule; the rule persists regardless of page refreshes or interaction settings. As a study tip, remember this principle: explicit rules beat theme defaults in Power BI. Whenever a question describes a visual that "won't update" after a theme change, your first instinct should be to look for a conditional formatting rule or manual override that needs to be cleared.

Question 4

Your organization requires the same visual-title font, label size, background color, and data palette in reports created by several developers. The standard must be reusable in new reports and should minimize repetitive visual-by-visual formatting.

Which workflow should you recommend?

Configure one report page, save it as a bookmark, and distribute the bookmark to all report developers.
Create and export a custom report theme, then have developers import the theme into their reports. (correct answer)
Publish one formatted visual to the Power BI service, then copy it into each developer's local report.
Store the required fonts and colors in a semantic-model table, then relate that table to every report measure.

Explanation: When a question asks about enforcing consistent visual formatting across multiple developers and future reports, you should immediately think about Power BI Themes — the built-in mechanism designed exactly for this purpose. A report theme is a JSON file that defines default settings for fonts, font sizes, background colors, data colors, and more. You create it once, export it, and any developer can import it into a new report via the View → Themes menu. Every visual added to that report automatically inherits those defaults, eliminating repetitive manual formatting. This makes B the correct recommendation — it's reusable, scalable, and purpose-built for standardizing visual appearance across a team. A is a trap because bookmarks capture a snapshot of a report's state (filters, selections, visibility) — not formatting standards. Sharing a bookmark doesn't give developers a reusable style template; it shares a view of a specific report page. C is impractical and doesn't scale. Copying a single formatted visual from the Power BI service into multiple local reports doesn't propagate a formatting standard — it just duplicates one visual. Any new visuals the developer adds won't inherit those settings. D confuses data modeling with presentation formatting. Storing colors and fonts in a semantic-model table has no effect on visual formatting properties in Power BI reports. Report appearance is controlled at the theme or visual level, not through data relationships. Study tip: On the Power BI exam, anytime you see "reusable," "consistent across developers," and "visual formatting" together, themes are almost always the answer. Know that themes apply defaults globally, while bookmarks capture state.

Question 5

A report page will be displayed on fixed-size kiosk screens. After publication, some chart titles and labels are automatically shortened or repositioned even though the report is viewed at the designed page size. The kiosk layout must remain predictable, and the visuals have enough space to show all required text.

Which change should you make to the affected visuals?

Convert the titles and labels to tooltips so they appear only when users point to a visual.
Enable responsive behavior and increase the report page's minimum browser zoom setting.
Turn on word wrap for every text element and leave the visual dimensions unchanged.
Disable responsive behavior and verify that the fixed visual dimensions accommodate the titles and labels. (correct answer)

Explanation: When designing Power BI reports for fixed-size displays like kiosks, the key concept to understand is responsive behavior. By default, Power BI visuals are "responsive," meaning they automatically resize and reflow their content — including titles, labels, and legends — to fit whatever container or screen renders them. This is great for flexible dashboards but problematic when you need pixel-perfect, predictable layouts. Disabling responsive behavior (option D) tells Power BI to render visuals exactly as you designed them, preserving the fixed dimensions you set. Once you've done that, you simply verify that those fixed dimensions are large enough to display all required text without truncation or repositioning. This gives you the predictable kiosk layout the scenario demands. Option A is a workaround that hides information rather than displaying it — converting titles and labels to tooltips means users never see that text unless they hover, which defeats the purpose of labeling data clearly on a kiosk screen where interaction may be limited or absent. Option B misidentifies the problem. Enabling responsive behavior actually causes the automatic resizing you're trying to prevent. Browser zoom settings also don't control how Power BI internally reflows visual content. Option C (word wrap) only affects how text breaks across lines — it doesn't stop Power BI's responsive engine from repositioning or resizing elements. Leaving visual dimensions unchanged while keeping responsiveness enabled means the problem persists. As a study tip: on the Power BI exam, whenever a question mentions fixed screens, kiosks, or predictable layouts, your first instinct should be to think about disabling responsive behavior — it's the primary tool for locking down visual rendering.

Question 6

Two line charts placed side by side show defect rates for different factories. One factory's values vary within a narrow range, while the other factory's values vary across a much wider range. With automatic axis ranges, similarly sized slopes can represent very different absolute changes. Users must compare the magnitude of changes accurately.

How should you format the charts?

Set each axis minimum to its own lowest value and use identical data-label font sizes.
Keep automatic axis ranges and assign the same line color and title font to both charts.
Set the same custom minimum, maximum, display units, and decimal precision on both value axes. (correct answer)
Hide both value axes and rely on data labels formatted with the same decimal precision.

Explanation: When comparing two charts side by side, your goal is to ensure that visual slopes and distances genuinely represent equivalent magnitudes. If one axis runs from 0–5% and another from 0–50%, an identical slope on each chart represents very different real-world changes — a classic visual distortion trap in Power BI dashboards. To make cross-chart comparisons honest and accurate, you need to standardize every aspect of both value axes: the minimum, maximum, display units (e.g., percentage vs. decimal), and decimal precision. This is exactly what C prescribes. When both axes share the same scale boundaries and formatting, a steeper line genuinely means a larger absolute change, and users can trust their visual intuition. A is tempting but flawed — setting each axis to its own lowest value still allows different axis ranges, meaning slopes remain visually misleading. Matching font sizes is a cosmetic fix, not a data-integrity fix. B keeps automatic ranges, which is precisely the problem described in the passage: automatic scaling lets similarly sized slopes represent wildly different magnitudes. Matching colors and fonts addresses aesthetics, not comparability. D hiding the axes entirely and relying on data labels removes important context. Even with matching decimal precision on labels, users lose the ability to visually gauge rates of change across the full range — they can only read individual points, not interpret trends comparatively. For the exam, remember this rule: whenever two charts are meant to be compared, shared axis scales are non-negotiable. Any answer that adjusts formatting without unifying the axis range is only solving half the problem.

Question 7

Two clustered column charts use different measures and filters but must have identical title, legend, axis, background, and border formatting. One chart is already formatted correctly. You must preserve the second chart's existing field assignments, filters, and sort order.

What should you use?

Duplicate the formatted chart and rebuild its fields, filters, and sort order.
Use Format painter to copy the first chart's formatting to the second chart. (correct answer)
Export the current theme and immediately reimport it into the same report.
Copy the first chart and use Paste special to retain the second chart's data.

Explanation: When working with Power BI visuals, formatting and data configuration are two separate concerns — and questions like this test whether you know which tools affect each one independently. The Format Painter (option B) is exactly the right tool here. It copies visual formatting properties — titles, legends, axes, backgrounds, borders — from one visual and applies them to another, while leaving the target visual's fields, filters, and sort order completely untouched. This is precisely what the scenario requires: transfer formatting without disturbing the second chart's data configuration. Option A is the least efficient path and introduces significant risk. Duplicating the formatted chart gives you its formatting, but you'd then need to manually reconstruct all the fields, filters, and sort order on the duplicate — a tedious process prone to error, and one that defeats the purpose of having a clean starting point on the second chart. Option C is a misconception about how themes work. Exporting and reimporting a theme applies global styling defaults to the entire report, not the granular, visual-level formatting like specific title text or border thickness. It also wouldn't selectively target one visual, and it wouldn't preserve anything that deviates from the theme defaults. Option D sounds plausible because "Paste special" suggests precision, but Power BI's Paste special function retains the source visual's data context — it doesn't let you swap in a different visual's fields and filters. It solves the wrong problem. Study tip: On Power BI exam questions, whenever the scenario involves copying only formatting between visuals while keeping data intact, Format Painter is almost always the answer — it's built specifically for that workflow.

Question 8

A measure returns a numeric sales amount in the currency selected by a user. The value is already converted correctly. When USD is selected, the visual must use a dollar format; when EUR is selected, it must use a euro format. The measure must remain numeric for sorting, aggregation, and chart axes.

Which solution should you implement?

Create a conditional data-color measure that returns the selected currency symbol.
Use a DAX text-formatting function to return the amount with the selected symbol.
Set the visual's display units to Auto and place the currency code in its title.
Apply a dynamic format string to the measure based on the selected currency. (correct answer)

Explanation: Whenever you see a Power BI question requiring a measure to behave like a number but display like formatted currency conditionally, you're being tested on dynamic format strings — a feature that separates the measure's value from its presentation. Dynamic format strings let you write a separate DAX expression that returns a format string (like "$#,0.00" or "€#,0.00") based on any slicer or filter context. The measure itself stays numeric, so sorting, aggregation, and chart axes all work perfectly — the formatting is purely cosmetic and applied at render time. That's exactly what option D delivers. Option A misunderstands the requirement entirely. A data-color measure controls bar or point colors, not how values are formatted as currency strings — it has no effect on numeric display. Option B is a classic trap. Using DAX text functions like FORMAT() does produce a nicely formatted currency string, but it converts the measure's output to text. A text value cannot be sorted numerically, aggregated with SUM/AVERAGE, or plotted on a continuous chart axis — it breaks the very behaviors the question says must be preserved. Option C is a cosmetic workaround at best. Placing a currency code in the visual's title doesn't change how individual values are formatted, and it would require manual updates rather than responding dynamically to a user's currency selection. Your study tip: on Power BI exam questions, whenever you need conditional formatting that keeps a measure numeric, think dynamic format strings first. If a solution converts the measure to text, it's almost always wrong.

Question 9

A report uses several different visual types to display performance against target. Management requires the same semantics everywhere: dark green for substantially above target, light green for slightly above target, amber for slightly below target, and red for substantially below target. Categories appearing in each visual can change after refresh.

Which approach provides the most reliable color consistency?

Define four theme data colors in the required order and allow each visual to assign them by category position.
Assign colors manually to the current categories in every visual and lock the report page after publication.
Create a measure that returns the approved color for each performance band, and use field-value conditional formatting on each visual. (correct answer)
Sort every visual by performance and use the first four colors from the default visual palette.

Explanation: When Power BI questions involve consistent color semantics across multiple visuals with dynamic data, the critical concept is distinguishing between static formatting (which breaks when categories change) and measure-driven formatting (which recalculates on every refresh). The reason C is the right approach is that a measure returning a color hex code based on performance band logic—combined with field-value conditional formatting—means every visual evaluates color at render time, not at design time. No matter which categories appear after a refresh, the measure runs its logic and assigns the correct color automatically. This is the only approach that survives dynamic category changes while enforcing the exact approved palette. A is tempting because themes feel like a centralized solution, but theme data colors are assigned by category position in the visual, not by any business rule. If categories shift order or new ones appear, the color mapping breaks entirely—dark green could end up on an underperforming category. B fails for a similar reason: manually assigned colors in Power BI are locked to the category name as it exists at design time. When categories change after refresh, new or renamed categories receive default colors, destroying consistency without any warning. D relies on sort order to indirectly control color assignment, which is fragile—palette colors still map by position, and any sorting inconsistency across visuals means different visuals can display the same category in different colors. As a study tip: whenever you see "categories can change after refresh" in a Power BI formatting question, that phrase is your signal that only measure-driven conditional formatting can guarantee consistent, rule-based color across dynamic data.

Question 10

A currency measure is used in executive cards and in a transaction table. The cards must show values in millions with one decimal place, while the table must show complete currency amounts with two decimal places. The measure must remain numeric and must not be duplicated.

Which formatting approach should you use?

Format the measure as currency in the model, set card display units to millions, and leave table display units unscaled. (correct answer)
Set the measure's model format to millions, and override the table by increasing only its displayed decimal places.
Use a DAX text-formatting function in the measure, and select separate currency patterns in the cards and table.
Divide the measure by one million for the cards, and enable automatic display units for the transaction table.

Explanation: When Power BI questions mention a single measure appearing differently across multiple visuals, you should immediately think about the distinction between model-level formatting and visual-level display settings. The measure's format string in the model sets a baseline, while each visual's Format pane lets you override how units and decimals are presented — without touching the measure itself. Option A is correct because it respects all three constraints: the measure stays numeric (no DAX text conversion), it isn't duplicated, and each visual gets independent formatting. Setting the model format to currency ensures both visuals inherit a sensible default. Then, on the executive cards, you simply set Display Units to "Millions" with one decimal place in the visual's format settings. The transaction table keeps Display Units at "None" (unscaled), showing the full currency value with two decimal places — all without changing the measure. Option B fails because setting the model-level format to millions would affect every visual using that measure by default, forcing the table to fight against that setting rather than simply inheriting a neutral currency format. It inverts the correct approach. Option C is a critical trap: wrapping a measure in a DAX text function like FORMAT() converts it from numeric to text. Text values cannot be aggregated, sorted numerically, or used in further calculations — violating the "must remain numeric" requirement explicitly stated in the passage. Option D breaks the "must not be duplicated" rule. Dividing by one million requires either a second measure or modifying the original, and using automatic display units in the table doesn't guarantee the exact two-decimal currency presentation needed. Your study tip: whenever a question says "must remain numeric" and "must not be duplicated," immediately eliminate any answer that creates a new measure or uses FORMAT() in DAX.