Analyzing and Visualizing Data with Microsoft Power BI — Question 129
You create a KPI visualization in Power BI Desktop that uses the month as the trend axis.
You discover that the data is not sorted by month.
You need to change the sort order of the visualization.
What should you do first?
Answer options
- A. Convert the visualization to a different type.
- B. Remove the trend axis from the visualization.
- C. Modify the visual level filters.
- D. Modify the drillthrough filters.
Correct answer: B
Explanation
Removing the trend axis is the first step because it allows you to reset the sorting issue before re-adding it. The other options do not directly address the sorting problem and would not resolve the issue of months being out of order.