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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bo_afk
Post Patron
Post Patron

Sort by with legend

Hi,

 

I have a graph which shows sales for item categories on the x axis, and in the legend, I have year. This means I can see the sales value for items for each year (2018 and 2019 for now).

 

How can I sort the items by sales value but for 2019 only? Currently, when I use the sort by option, it sorts by the combined sales value of both 2018 and 2019.

 

Does anyone know how/if this is possible?

 

Thanks

 

afk

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@bo_afk ,

 

You can create a slicer visual based on year column and select year 2019. This will filter the other visuals on year 2019.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yuta-msft , thanks for your response.

 

I don't want to filter the visual for 2019, I would like to sort the values by descending order for 2019. But I still want to see the values for 2018 for these categories as well.

 

Hope this makes sense.

 

afk

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.