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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
cosminc
Post Partisan
Post Partisan

graph sort by year and dax variables - max month, max year

Hi

i have a source like bellow and in a relationship with a calendar and i'm stucked in this:

i want to obtain 2 graphs like this:

1. top 15 salesmen by sales from maxyear (2019 in this case) with comparable periods from previous 2 years (not full years);sorted by sales 2019, not all three; and the graphs need to be with the bars inverted - up 2019 not like now where is 2019 is last

2. same top but with monthly data - last month data 2019 (max year), previous month and same month last year; sorted by top sales from last motnh data

Thanks a lot in advance!

Cosmin

Untitled.png

 

YearMonthNoSalesmanSales
20191George7
20181George97
20182George19
20183George82
20184George82
20185George73
20186George30
20187George100
20188George89
20189George48
201810George86
201811George62
201812George41
20171George82
20172George87
20173George69
20174George11
20175George2
20176George12
20177George72
20178George54
20179George19
201710George95
201711George40
201712George17
20191Jason31
20181Jason12
20182Jason44
20183Jason42
20184Jason39
20185Jason95
20186Jason83
20187Jason77
20188Jason90
20189Jason77
201810Jason2
201811Jason84
201812Jason89
20171Jason37
20172Jason73
20173Jason37
20174Jason6
20175Jason34
20176Jason70
20177Jason87
20178Jason45
20179Jason76
201710Jason100
201711Jason3
201712Jason64
1 REPLY 1
Greg_Deckler
Super User
Super User

What? 

 

Top 15 with comparable 2 previous but not full years but not all 3 but with 2019 first...? I didn't get all that. And your data only has 2 people in it so hard to do what you are asking with the data provided.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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