Custom visuals from marketplace in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Custom Visuals Installation

You want to add a new custom visual from the Power BI marketplace to your report. What is the correct first step?

A Open the Visualizations pane and click on the 'Get more visuals' icon to browse the marketplace.

B Download the visual from an external website and import it directly without using Power BI interface.

C Create a new visual from scratch using DAX expressions in the report canvas.

D Use the Power Query Editor to add the custom visual as a data source.

💡 Hint

Think about where Power BI provides access to official custom visuals.

The correct way to add a custom visual is through the Visualizations pane by clicking 'Get more visuals'. This opens the marketplace where you can browse and add visuals safely.

❓ dax_lod_result

intermediate

DAX Measure Behavior with Custom Visuals

You created a DAX measure that calculates total sales. You use a custom visual from the marketplace that supports drill-down. What happens to your measure when you drill down in the visual?

Power BI

Total Sales = SUM(Sales[Amount])

A The measure always shows the grand total sales regardless of drill-down.

B The measure recalculates to show total sales only for the drilled-down category or level.

C The measure returns an error because custom visuals do not support DAX measures.

D The measure shows the average sales instead of total sales when drilled down.

💡 Hint

Think about how DAX measures respond to filters applied by visuals.

DAX measures recalculate dynamically based on the current filter context, including drill-down selections in visuals, custom or built-in.

❓ visualization

advanced

Choosing the Best Custom Visual for Time Series Data

You want to visualize monthly sales trends over two years with the ability to highlight specific months. Which custom visual from the marketplace is best suited for this task?

A Use the 'KPI Indicator' visual to show only the current month's sales value.

B Use the 'Chiclet Slicer' visual to filter data by months in a grid layout.

C Use the 'Timeline Storyteller' visual to create an interactive timeline with highlight features.

D Use the 'Card Browser' visual to display sales values as cards without trend lines.

💡 Hint

Look for a visual that supports time-based data and interactive highlighting.

'Timeline Storyteller' is designed for time series data and allows users to highlight and explore specific time periods interactively, making it ideal for monthly sales trends.

🔧 Formula Fix

advanced

Troubleshooting Custom Visual Import Failure

You try to import a custom visual (.pbiviz file) downloaded from the marketplace, but Power BI shows an error: 'Visual import failed due to unsupported version.' What is the most likely cause?

A The .pbiviz file is corrupted and cannot be opened by Power BI.

B The visual requires an internet connection, but your computer is offline.

C You did not enable the 'Allow custom visuals' option in Power BI settings.

D The custom visual was built for a newer Power BI version than your desktop supports.

💡 Hint

Consider compatibility issues between software versions.

Power BI desktop may reject visuals built for newer versions if your software is outdated. Updating Power BI usually resolves this.

🎯 Scenario

expert

Designing a Dashboard with Multiple Custom Visuals

You are designing a sales dashboard using three different custom visuals from the marketplace. You want all visuals to interact with each other so that selecting data in one filters the others. What must you ensure for this to work correctly?

A All custom visuals must support cross-filtering and be configured to allow interactions in the report settings.

B You must write custom DAX code to link the visuals manually for interaction.

C Custom visuals cannot interact with each other; only built-in visuals support interaction.

D You need to import all visuals from the same developer to ensure compatibility.

💡 Hint

Think about how visuals communicate filter changes in Power BI.

Custom visuals that support cross-filtering can interact if report interactions are enabled. No extra code or same developer requirement is needed.