How to plot Bar chart with Y axis left for amount and right for Count ?

[admin11]

Hi All

Due deal Amount very large and count of deal very small , now both put on left axis , end up unable to see the different. 

May i know how to set Amount on left , Count on right ?

Paul.

[v-henryk-mstf]

Hi @admin11 ,

According to your needs, display its quantity for the created measure. You can refer to the following operations:

Get the final result:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[PhilipTreacy]

@admin11 

Hi Paul,

To turn on the Secondary Y axis, go to Format, find Y Axis and open it, then scroll down

Until you see Show secondary and turn that on.  You don't need to set the Secondary axis for the Line, that is already done automatically.

But you do need to provide some data for the Line value

But _Count_Deal is 0 so there's nothing to show.  You'll just get a horizontal line at 0.

Regards

Phil

[admin11]

@PhilipTreacy 

Thank you for providing me very detail instruction. 

Actually the _Count_Deal is not zero. Now get zero is because the unit in million. 

The reason i need count to be at right axis is from the chart , number deal is not impt , impt is amount of value of deal.

Hope you can show me how to change the scale of the _Count Deal not in million.

Paul

[Shishir22 · Accepted solution]

Hello @admin11,

I would suggest using count as line as comparing tow bars one with values in millions and one in tens/hundreds will not give correct impression and might confuse end users.

As @PhilipTreacy mentioned secondary axis is for line. You can enable it from y axis - Show secondary option present in formating option.

You can also try option of allign zero too after enabling secondary axis for line. 

Thanks! 

[admin11]

@Shishir22 Thank you for sharing , can you pls share with me where to turn on show second axis ? i cannot find it.  also how to set second axis for line ? instead of bar ?

Paul Yeo

[PhilipTreacy]

@admin11 

Hi Paul,

The Secandary axis on that chart is for the line,not the column values.

But your Count is 0 anyway, so even if it was on another secondary axis it would still be 0?

Regards

Phil