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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!