exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 60 discussion

Actual exam question from Microsoft's 70-778
Question #: 60
Topic #: 1
[All 70-778 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Richa
Highly Voted 5 years, 7 months ago
Answer should be A. KPI doesn't have SORT option. You need to start over again.
upvoted 21 times
...
amar111
Highly Voted 5 years ago
COrrect answer is B . They have mentioned in question - "You need to change the sort order of the visualization." and changing visualization to something is a very generic answer . So you need to remove month from trend axis -> sort it by month number -> Again put it in Trend axis
upvoted 10 times
rethe_109
5 years ago
correct by removing it from the trend axis will solve it.
upvoted 1 times
Echicken69
4 years, 10 months ago
So... I just tried this and my KPI just ended up blank? Am I doing this wrong? Can you use a KPI without applying any data in to the Trend Axis and just use Indicator and Target goals fields? How do you do this? Also how does the answer achieve what is being asked "You need to change the sort order of the visualization", if you remove the Trend Axis [assuming the Month Column value] from the visualization, then how would you sort the visualization by? By Target Goal value? The Indicator value? Where do you put the Month Column then? The answer doesn't make sense.... I would go with A logically.
upvoted 2 times
...
...
...
Enkuliche
Most Recent 1 year, 7 months ago
C "Modify the visual level filters," is the appropriate choice because it allows you to control the sorting order of the data within the existing KPI visualization. You can adjust the filter settings to sort the data by month, ensuring that it appears in the desired order on the trend axis.
upvoted 1 times
...
b_o_b_a
2 years, 9 months ago
Selected Answer: A
A seems correct since that is what Microsoft recommends: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
upvoted 1 times
...
Harry96
3 years, 5 months ago
Selected Answer: A
Answer should be A. KPI doesn't have SORT option. You need to start over again.
upvoted 1 times
...
CDL
4 years, 6 months ago
A is correct, converting to different visual type just in order to view the month sequence, and then go to Table View, selecting the month column, and click “Sort by column” under Ribbon Tab “Table Tools”, selecting the “Sort by Month #”, and back to Visual interface, check the result (month(text) sequence), if ok, convert back to KPI visual. Key Note: Once you convert the visualization to a KPI, there's no option to sort. You must sort it correctly now. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi#how-to-create-a-kpi Create a custom KPI Card in a Power BI report, very interesting one not related to Exam. https://www.youtube.com/watch?v=zHzSBNES6jE
upvoted 2 times
...
eug45
4 years, 8 months ago
Answer is A https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
upvoted 1 times
...
cromastro
4 years, 8 months ago
A. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
upvoted 1 times
...
frakcha
4 years, 8 months ago
This exam is really tricky tbh, it should be A not B
upvoted 2 times
kyliek7
4 years, 5 months ago
haha, really tricky, and I agree with you :D
upvoted 1 times
...
...
varshiii
4 years, 9 months ago
option A is correct answer https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
upvoted 1 times
...
123
4 years, 9 months ago
Convert... https://community.powerbi.com/t5/Desktop/Need-to-change-the-sort-order-of-the-KPI-visualization-that-uses/td-p/719092
upvoted 1 times
...
r8d1
4 years, 10 months ago
i think it is B sort the column that goes into the trend axis. Which means you will need to remove it first. https://community.powerbi.com/t5/Desktop/KPI-trending-axis/td-p/90699
upvoted 2 times
...
NasheM
4 years, 10 months ago
Shouldn't it B. If you remove the axis you can sort it then put it back after it's sorted?
upvoted 2 times
...
ioioyou
4 years, 10 months ago
I think it's A after I read the references. But I met a problem experimenting with sorting. The KPI visuals stay the same when I sort the month ascendingly or descendingly (I sort before I turn the bar charts into KPI). What does that mean?
upvoted 1 times
...
Jayanthan
4 years, 12 months ago
We can sort using "sort by column" without removing month from the trend axis, then what would be the answer
upvoted 2 times
Echicken69
4 years, 10 months ago
How do you do this? I have tried finding it... it only gives me the following options...Remove Field, Rename, Move to, New quick measure, Show items with no data & New group?
upvoted 1 times
...
...
lozqt
5 years, 2 months ago
Correct Answer is A. "Once you convert the visualization to a KPI, there's no option to sort. You must sort it correctly now." --> https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi To sort your month out you need to convert back to a visual, use the ascending or descending sort option and convert it back again to KPI. The KPI visual does not have a sorting option.
upvoted 2 times
...
szaf
5 years, 2 months ago
Answer is Definitely A. you can't sort on KPI but if you need to sort change it to other visualization, go to sort option and then sort it and change the visualization back to KPI.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago