Dual Scale Y-Axis Chart

#1

Hello,
I have timeseries dataset as below with Asset, KPI ,Timestamp and Value.
image
I want to plot 2 KPI for same asset having different scale value and one KPI is not calculated from other…no any formula relation.
If I select both KPI I get common Y-Axis however scale are different hence unable to do analysis.
Can we fix first KPI Scale on Left axis and second on right axis having Values coming from column ‘Value’ i.e. only one series and X-axis will show timestamp.
Appreciate you response.

Regards,
Prashant

#2

Hi Prashant,

Please give the steps in this video a try. Essentially, you need to create a chart with two metric sets so that you can put the second series onto it’s own axis.

how%20to
how to.gif1920×1040 3.19 MB

If you’re still having trouble, come find us!

2 Likes
#3

Simply Great Jeff!!! This is uniqueness of Dundas BI over other visualizations. I am struggling for same feature in SSRS - MSBI.

2 Likes