How to select dynamic secondary axis from slicer?

sharmavicky · ‎02-17-2023

Hi Everyone,

I have a line chart which i have prepard form table. Here are table operations i have applied.

Here i have unpivoted few columns and i am using this to make line chart.

As you can see i have selected the inflation_rate in variable slcier like wise there are other variables exist in slicer.

So if i select one more in slicer (my chart look like this)

As you can see the y-axis, the interval drastically changes and makes it dificult to read and draw any conclusuion

1. is there a way to change interval, which i guess not possible
2. Is it possible to change primary and secondary axis when selected in scilers i.e. example ave_temp in primary axis and inflation rate in secondary axis
Note: here are fix rule set
1. On landing page view all the variables are seletced by default

2. If more than three variables or only single variable are selected in sclier then default view i.e. every thing on primary axis is fine and works as in step 1 (which is by default taking palce)
3. Once any two variable selected then dynamically one should go in primary and other in secondary

Thanks in Advance