1 of 1 people found this helpful
You can only synchronize the axis in case of dual axis when your both the measures are of same data types.
See the example
For dual axis you've to drag two measure in row shelf. Then right click on the highlighted measure and select dual axis
Once you select dual axis your bar chart will circle go to marks card and select bar chart for the respective measure.
Now If you see right axis is not aligned with left. Once you click on synchronize axis your graph will be aligned with left axis.
Final view. You can remove the header from right side just uncheck the show header.
This is for synchronize the axis
However as per your requirement. I thing fixed axis will be helpful.
If you see both(left:Sales and right: Profit) the charts have different axis ranges.
To I've to set the range of right chart as per left chart. If you right click on the axis of the Sales chart you'll get this view
Now make it fixed from automatic range and copy the fixed start and fixed end values and paste it in the Profit chart axis using edit axis. Like this
I hope this may help you. Let me know If you've any query.
Thanks for your detailed response. The requirement is to have two different graphs and not create a dual-axis.Also these two graphs have different datasource .
Hmm! That's fine I'm asking you to just fixed the axis. Is there any issue with fixing the axis?
If you've get any mismatch then you can share the screen shot of edit axis for both the charts
I got you.I am aware of the standard formatting techniques to sync the axis.Fixing the axis does not work in my case because the range of values for the same metric is different for different industry.Also there are non-standard formatting techniques which Jonathan Drummey has shared which is what I am trying to implement.But no success so far.
Then I thing you should teach your interactors to treat both the chart individually.
Do you have a sample workbook.
If you create 2 of the same dual axis graphs
sync the axis on each graph
On first one don't give a mark to axis one
on second one don't give a mark to axis 2
this should hopefully fix the problem
If you have a smaple workbook I can create this and send it back.
3 of 3 people found this helpful
I recently had this issue. Three charts, all individual charts, on the same dashboard. I wanted to be able to show the same axis.
The solution is to create a Fixed LOD calculation that you can then use as a reference line. Your calculation will have to be a number that will be the "max" of all the metrics shown. In your example, something like "MAX(first metric)+500" or something. For my chart below, I used the max of the left-most chart's measure and added some for padding.
Then on each of your charts, set a reference line to equal that specific calculation. Now here's the kicker: make the reference line invisible. Show no line, no shading, no label. The reference line will technically be there, but your user would have to hover over it to see anything.
Here's my result: