How to plot Revenue vs Net Profit ?

[Anonymous]

Hi All

It is possible to have 2 seperate Y axis scale ? 

[PhilipTreacy]

Hi @Anonymous 

You shouldn't have to select secondary axis for different brands, should be set for the chart. Might be some buggy behaviour?

Phil

[Anonymous]

Hi Phil

Yes you are correct , for secondary axis must be set on chart. i think there are some bug. that is the reason why Omron already able to work and when switch to Precicon it does not work.

Paul

[PhilipTreacy]

Hi @Anonymous 

Did you turn on the Secondary Axis for the Y axis?

With OMRON selected double check the Format section for the chart - Scroll down to Y axis and open it, then scroll down to Show secondary and make sure it is on.

See this PBIX file for working visual.

Phil

[Anonymous]

Hi Phil

Once again , thank you very much for your help.

i find it quite funny. Why i need to select individual brand and set secondary Y axis , i assume it should be automatic set for any brand i select from Slicer ? don;t need individual select each brand and turn on secondary Y axis right ?

I just check on my actual PBI file , i notice that i have about 8 brand , now 7 brand have left and right Axis except only one brand dont have.

Now very confuse.

Paul 

[PhilipTreacy]

Hi @Anonymous 

Here's your PBIX file with the below changes/chart

Switch to the Format tab/area and turn on Secondary Y Axis

Then back on the Fields tab move the AMT NET_PROFIT_A_TAX_C values to the Secondary values 

Giving this

Regards

Phil

[Anonymous]

Hi Phil

Many thank , now it work fine for PRECICON.

when i change to OMRON , it cannot work :-

Where i go wrong ?

Paul

[themistoklis]

@Anonymous 

Yes there is. You can select either Line Chart and in the format pane you will see the option of Secondary Y Axis... or Line and Stacked Column Chart where you can turn on the secondary axis (see below)

[Anonymous]

Hi Themis

I try but still unable to locate it.

below is my PBI file :-

https://www.dropbox.com/s/j7g53rpz32s2btw/COMPETITOR_V006.pbix?dl=0

Can you pls share with me how to set it.

Paul