Forum Discussion
How to plot Revenue vs Net Profit ?
Hi All
It is possible to have 2 seperate Y axis scale ?
8 Replies
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)
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
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
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
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
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
