Showing results for 
Search instead for 
Did you mean: 
Post Partisan
Post Partisan

Is there anyway to show mutiple measures on different years

i have the requiremnt like in below where i need to show the two mesaures on different years using line chart . Is there any possible way to achieve it?




here if you see above screenshot i have two measures and three fiscal years currently i have differentiated by years like year+month .since i was not able to different on categorical year on the top with the quateters .I was able to do with single measure but not with two measures . Is there any way to achieve this?

Not applicable

Hey @adithyanaini 

I dont see a reason why not.

What's the exact issue you encounter?

2019-07-10 08_51_12-Window.png





@Anonymous : Yes if you see at year level i was able to do . But when i drill to quarter and month level i need the split based on year  with two measures . Something like below but i have currently only one measure . Hope yu got it?





Not applicable


I did not get it.

It will help if you provide sample data and/or your PBIX file.



date    sales              purchase


10/2/2019         20                       10

10/3/2019        30                         5

10/2/2018         45                      3

10/1/2017                   34             4


with the above data i need to show the sales and purchase with drill down to year ,qurter and month . At the year level i can show the sum(sales),sum(purchase) . But when i drill to quarter and month i need the categorization with year


label : 2017,2018,2019           and  y axis : measure values   and x axis : q1,q2,q3,q4


But currently i was not able to develop this view . Is there any other way to better represent this view with two measures with drill down  feature?


Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors