cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adithyanaini
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?

 

categoricalmeasure.jpg

 

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?

4 REPLIES 4
Anonymous
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

 

Thanks!
A

yearhiearchy.jpg

 

@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?

 

 

onemeasure.jpg

 

Anonymous
Not applicable

Sorry,

I did not get it.

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

Thanks

A

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

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

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
Top Kudoed Authors