Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 19
Your colleague works with a data model to analyze the performance of the company’s offline stores.
So, he creates a KPI visual to compare how the revenue in the current quarter compares to the revenue from the previous quarter.
The below representation shows the measures/fields used to build the KPI visual.
But there is something off with the visual. The KPI displays a much higher value (33859) than the goal (Revenue Last Quarter). But you cannot observe this behavior in the trend chart in the background (which is continuously decreasing each quarter).
To debug the issue, you check the underlying data for the visual.
What could be wrong with the visual?
Note:
1. Offline Store Revenue table contains historical (at least four years) revenue data for the company’s offline stores.
2.
- Revenue Last Quarter =
- IF (ISBLANK([Total Revenue]), BLANK(), CALCULATE ( [Total Revenue], PREVIOUSQUARTER( 'Date'[Date] ) ) )
-
A
Using the field Quarter in the
trend axiswell is incorrect since many years of data are available -
B
The usage of fields in the indicator and the
target goalwells is incorrect. They should be swapped -
C
The
total revenuevalue is much higher than the target because it evaluatestotal revenueacross all quarters -
D
There is some issue with the
Revenue Last Quartermeasure used in thetarget goalswell since it displays a very low value
Reveal correct answer
Correct answer: A
Explanation
Since the Offline Store Revenue table contains four years' worth of data, using the Quarter field in the trend axis computes the cumulative quarterly revenue across all four years. That’s why we have only four plotted values in the trend chart.
This is unhelpful because the visual doesn't display how the revenue changes across different quarters (trend is not meaningful). More importantly, it also doesn't display the current quarter's revenue.
The discrepancy in the chart is explained by the fact that there is no meaningful comparison between the current and the previous quarter (Revenue Last Quarter displays values for a specific quarter vs. cumulative value for Total Revenue).
The solution is to create a new column that can uniquely identify a quarter across many years. I use the format function to format a column with year and quarter combination.
And use the Year Quarter field in the trend axis.
Now, the data is sliced correctly, and the KPI visual is accurate. Option A is the correct answer.
Option B is incorrect. Your colleague creates a visual to compare how the revenue in the current quarter compares to the revenue from the previous quarter. So, using the metric Total Revenue in the indicator well, and the Revenue Last Quarter in the target goals well is correct.
Option C is incorrect. It is true that Total Revenue indeed evaluates revenue across all quarters. But we can slice the measure according to the granularity we require by using an appropriate field in the trend axis well.
Finally, there is no issue with the definition for the Revenue Last Quarter measure (given in the question). You can check with your dataset. Option D is incorrect too.
PBIX File Link: Debug issue with a Power BI visual
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
