Personalize Visual Scatter chart - dynamic fixed axes scale per measure

[Anonymous]

Hello,

Is there a way to dynamically change the min and max values of X/Y axis scale values, to a fixed predefined value based on certain conditions, in Scatter Plot when a different measure is selected using Personalize Visual option? I tried using Calculation Group Measure using IF and ISSELECTEDMEASURE() combination and tying the mesaure to scatter plot x/y axis scale properties, but it does not seem to work as expected. Any help would be greatly appreciated.

Thanks

Nirmit

[Anonymous]

An update for benefit of others reading - SELECTEDMEASURENAME is special function which works only when used within Calculation Item. Since I was using it in a regular Calculated Measure, it of course had no effect. 
Havig said that, it still does not resolve the issue since Calculation Items cannot be tied to axis Scale property. Thus the question in the conext of Personalize Visual setting still remains.

[Anonymous]

Hi @Anonymous 

Have you tried with a SWITCH and SELECTEDMEASURENAME()? 

In case it still doesn't work, can you share an example or some more details?

Thanks!

[Anonymous]

Hi @Anonymous,

Thanks for quick reply. Yes I have tried with that too, but to no luck. Sharing below the code and results. Have demonstrated it in a Line chart for now for quick sketch but I assume measure behavior will be same for Scatter chart too.

dynamic axis scale = 
SWITCH(
    SELECTEDMEASURENAME(),
    "Net Sales", 3000000,
    "Volume", 1000000,
    999
    )

Results: dynamic axis scale returning default value 999 and thus no value in graphs. Expected results are as shown in right side graph. Notably there are 2 slicers also in the bottom which are controlling the Sales and Volume measure values. But again this should not intervene with "dynamic axis scale" mesaure calculation.

Thanks

Nirmit