Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm using a line and stacked column chart. The 2nd y-axis on the right represents my line graph scale. The formatting option for this chart type only allows you to amend the x-axis and y-axis - how can I amend the 2nd y-axis?
I am just looking to set the 'start' point of this 2nd scale as 0.
If this cannot be directly formatted, is it possible to add a hidden 0 field for one of the months in my chart to force the scale down? If for example, I included Dec-18 with a 0 value, could I use this to force the 2nd y-axis to 0, but hide the Dec-18 data on the chart?
Many thanks,
Mike
Solved! Go to Solution.
Argh, I realised that even though my 2nd y-axis is working and visible, you have to scroll down the y-axis options and select 'show secondary', which then opens up the relevant formatting options 🙂
@PBIMike , In Visualization format you have Start and End option for axis.
Argh, I realised that even though my 2nd y-axis is working and visible, you have to scroll down the y-axis options and select 'show secondary', which then opens up the relevant formatting options 🙂
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |