Given a Card visual showing the measure Total Sales with a value of 5000, what will happen if you add a filter to show only sales from 2023?

medium📝 Formula Result Q4 of 15

Power BI - Basic Visualizations

Given a Card visual showing the measure Total Sales with a value of 5000, what will happen if you add a filter to show only sales from 2023?

AThe Card will update to show total sales only for 2023

BThe Card will still show total sales for all years

CThe Card will show an error message

DThe Card will display the average sales for 2023

Step-by-Step Solution

Solution:

Step 1: Understand Filter Impact on Card Visual
Filters applied to the report or visual limit the data shown. So filtering by 2023 restricts data to that year.
Step 2: Effect on Total Sales Measure
The Card recalculates the measure based on filtered data, showing total sales only for 2023.
Final Answer:
The Card will update to show total sales only for 2023 -> Option A
Quick Check:
Filters affect Card values dynamically [OK]

Quick Trick: Filters change Card values to match filtered data [OK]

Common Mistakes:

Master "Basic Visualizations" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes