Synchronize chart value

[admin_xlsior]

Hi,

May I know how to synchronize values of different visual (charts) under same page ?

Example attached, 

1. Values in Y axis for chart no 1 is up to 200, but the other is 50. Understand this is because of the measures value, but it's not good representation when the chart looks at the same heights but actualy different range
2. While the 2 & 3 charts is under same value Y axis (max 20), somehow the X axis is not align.

I've been looking for the configration setup but could not find any.

Thanks in advance

[TeigeGao · Accepted solution]

Hi admin_xlsior,

According to your description, my understanding is that you want to make all chart visuals using the same X, Y scale.

For Number data type in X and Y axis, we can use Ctrl + Click to select all chart visuals, then change them in Format -> X axis / Y axis -> Start / End.

For other data types in X axis, we can change the measure like below:

measure = var a = ***
return IF(a=0,0,a)

After that, we can change the sort by column, please refer to the following picture:

The result will like below:

Best Regards,
Teige

[admin_xlsior]

Hi Teige,

It works.

Many thanks. I didn't understand the second part, but the 1st is the one I need I right now. 🙂

Thanks again.

[TeigeGao]

Hi admin_xlsior,

The second part shows how to make the X axis usinng the same format.

If the measure cannot get a data zero, it will hide this part in X axis, in this scenario, we can use the  IF(a=0,0,a) to display this part.

Best Regards,

Teige