cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Babulal
Helper I
Helper I

Align axis in Line chart

In the below Line chart visual in screen shot 1, Sales Target is drifting too high driven by its numbers compared to Current and Prior and causing too much variation in the chart, is there a way to minimize by bringing Sales Target around middle of the chart dynamically.

 

Screen shot 1 (with Current, Prior and Sales Target):

LineChart.PNG

 

Screen shot 2 (without Sales Target): 

image.png

 

Screen shot 3 (Format):

 

Format.PNG

1 ACCEPTED SOLUTION
Babulal
Helper I
Helper I

Hello @negi007 ,

 

I greatly appreciate your time into looking into this and i found a solution which looks like the following which I was expecting.

 

Line Chart:

Babulal_0-1632673335666.png

I moved Prior from Secondary values to Values as per below screen shot.

Format:

Babulal_1-1632673371258.png

and then by changing Format Pane ->Secondary Y axis->End = function as Median of Sales Target

 

 

View solution in original post

3 REPLIES 3
Babulal
Helper I
Helper I

Hello @negi007 ,

 

I greatly appreciate your time into looking into this and i found a solution which looks like the following which I was expecting.

 

Line Chart:

Babulal_0-1632673335666.png

I moved Prior from Secondary values to Values as per below screen shot.

Format:

Babulal_1-1632673371258.png

and then by changing Format Pane ->Secondary Y axis->End = function as Median of Sales Target

 

 

View solution in original post

@Babulal However, this visual will given an impression that target has been achived which is not the case. in such cases, it is not advisable to use target in the secondary axis as both actual and target measurement unit are same. But it is upto you how you present and explain it to your audience. cheers!!!




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


negi007
Super User
Super User

@Babulal in this case , you can try logarithm scale like below. change the y-axis like below

 

negi007_0-1632669756010.png

negi007_1-1632669854257.png

i hope this helps you




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.