Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Cards able to sort by date when displaying by Month or Work Week over multiple years

Whenever a card is using Month or Work Week as its date axis and it crosses over into a new year, it defaults to sorting either alphabetically, by month order, or by week number without regard to what year these weeks/months are in. This happens especially when you need to resorting using categorical axises, since sometimes using continuous eliminates granuality when it's not given enough space.

For example, you're displaying the last 3 months of data, and January comes along, and suddenly your cards display like this:
https://i.ibb.co/6nY9jgZ/Annotation-2020-01-17-032925.png

Even when using another column in the date table to sort by, card still default to thier own internal context of displaying alphabetically or numerically.
Some other workarounds may exist but they come at a compramise in the format you're able to display with.

It would be a great addition if cards were able to sort the x-axis taking the full date into context, such as year when sorting months or weeks, and months when sorting date numbers.

 

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may change the Type option from Continuous to Categorical and sort by a date column, then take advantage of Visual level filters to hide certain X axis labels.