Sorting Correctly By Month Name In Power BI
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1By default, how does Power BI sort visuals by category?By positionBy sizeBy colorBy number or alphabetically30s
- Q2What visual is used in this video to demonstrate custom sorting?TableLine ChartPie ChartZebra Bi Charts30s
- Q3In the video, what is the initial sorting logic applied to the month names?Alphabetical (A to Z)By month number (January to December)From biggest value to smallest valueReverse chronological order (December to January)30s
- Q4How can you change the sorting logic of a visual in Power BI?Click on the three dots next to the visual and change the sort logic from the values field to the category field.There is no way to change the sorting logic of a visual in Power BI.Edit the formatting of the axis.Change the data type of the category column.30s
- Q5Which of the following is the additional column used to sort the month names by their actual month number?YearMonth NameCalendar YearMonth Number30s
- Q6Once you have sorted a column by a custom order, will Power BI remember this sorting logic for future visuals in the same report?YesNoPower BI will only remember the sorting logic for the specific visual you applied it to.Only if you save the report as a template.30s
- Q7What does the Zebra BI Knowledge Base offer in relation to custom sorting in Power BI?A paid add-on for custom sorting functionalities.Knowledge base articles and downloadable files demonstrating custom sorting techniques.Pre-built custom sorting templates.There is no information available in the Zebra BI Knowledge Base on custom sorting.30s
- Q8What are some of the common scenarios where you might need to use custom sorting in Power BI reports?There is no need to use custom sorting in Power BI reports.When you need to highlight the largest or smallest values in a data set.When you want to group similar data points together.Time series data over different periods, such as months or quarters.30s
- Q9Which of the following statements is FALSE about custom sorting in Power BI?Custom sorting can be applied to both categorical and numerical data.Sorting alphabetically is always the best way to sort data in Power BI.You can define a custom sort order for any column in your data set.Custom sorting can be helpful for making your reports easier to understand and analyze.30s
- Q10In the video, how did the user achieve the final desired sorting order (January to December)?None of the above answers are correct.They created a new calculated column that combined the month name and month number, and then sorted by this new column.They selected the month name column in the fields list and used the sort by column function to sort by month number in ascending order.They clicked on the three dots next to the visual, changed the sort logic to month name, and then clicked sort ascending.30s