Slicer on y-axis values

[Dunner2020]

Hi there, I have a line graph that shows some percentage value. The x-axis contains the time period (in the format of Month and Year) that comes from 'Time' table and the percentage values comes from fact table and plotted on y-axis. The graph looks like as follow:

I want to change my fixed y-axis percentage values to something like a dynamic slicer where I can change the value of y-axis as shown in the following picture:

I am not sure how to do that. Any help would be appreciated in achieving the task. Thank

The axis contains the time period which comes from 'time' table, and value of percentage of customers with an issue comes from Overfivepct_SAMPLECustomer table. The y-axis shows the percentage value from 0% to 100% and it is fixed. I want to change its fixed y-axis (0 to 100%) values to slider on y axis so that I can change the value of percentage of y axis using slider. How to do that ?

[Anonymous · Accepted solution]

Hi @Dunner2020 ,

You can turn on the Zoom Slider in the line chart.

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.