Check this link: - Dual Axes
But here you have 3 axis of approx same amount values & one is of different amount of values. For this put 3 different measures with Measure Values & one without Measure Values. Check the attached file for your answer.
Always try to attach a sample workbook (.twbx) & when you will get correct answer of your problem, just mark correct answer to correct.
Dual Axis.twbx 965.1 KB
Hi Prashant Sharma,
The link is for diff type of measures, correct?
This is actually the problem am facing now. Pls find attached sample:
I put "Res" as a dimension and group it into 4 groups. So the "Images" group have a big numbers while the other 3 are not. How I can move the other 3 to the secondary axis. Thanks
Check the file attached by me in previous reply. That solution may work for you. Following are the steps: -
1) First put dimension in column.
2) Put Measure Names from dimension section to filter & choose those 3 measures which are having small values.
3) Put Measure which is having large values in row.
4) Right click & choose Dual Axis.
For more check my attached file from previous reply. Hope this may work for you.
Still cannot be done. Your example is for two diff dimensions but mine is from one dimension which is "res".
Herewith I attached an images that I'm working at the moment. btw, how can I attached a worksheet since my data connection is from SQL server. If possible then more easier for you to see.
If what you want to communicate is whether the rate of change is similar for items in 'res', then the simplest would be to use a logarithmic axis - right click on the axis > Edit Axis > Scale >chose logarithmic. Check out Stephen Few on Dual-Scaled Axis and Using Log Scales - great insight.
Hope that helps!
Yeah, I also think this is the only way to do. Thanks everyone for sharing the info.