Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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):
Screen shot 2 (without Sales Target):
Screen shot 3 (Format):
Solved! Go to Solution.
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:
I moved Prior from Secondary values to Values as per below screen shot.
Format:
and then by changing Format Pane ->Secondary Y axis->End = function as Median of Sales Target
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:
I moved Prior from Secondary values to Values as per below screen shot.
Format:
and then by changing Format Pane ->Secondary Y axis->End = function as Median of Sales Target
@Anonymous 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!!!
Proud to be a Super User!
@Anonymous in this case , you can try logarithm scale like below. change the y-axis like below
i hope this helps you
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |