Automatic scaling on Y axis

[Arnault_]

Hi All,

I have seen different thread about the same issue. I have not seen any proper answer. Here is my problem.

I would like to Y axis to adujst to the values displayed on the visual. In the foramtting option, I choose "auto".

I don't want to fix it to Millions or Thousands for two reasons:

- I use a switch function to change the measures based on the slicer selection: number of oreder lines are likely to be "thousands or less" and financial value are expressed in "Millions".

- The second reason is that the user can filter down by using different slicers and choosing a format by default would not be suitable. If I set it to Millions, even in the granular level of filtering it will show 0.00M which is not acceptable. In any case it should not show Billions, since the figures are not high enough to display it as Billions.

See the example below:

Now, I have noticed something weird (second image). I have just copied / pasted the visual and change the size (second chart on the right), then the auto scaling feature works... WTF !!!

Is there any possibility to fix this?

Thanks

[amitchandak · Accepted solution]

@Arnault_ , I think Auto is best option. I think you are using measure slicer, shift in scale might not be soo smooth.

Measure slicer using calculation group might be better option , check - https://www.sqlbi.com/articles/introducing-calculation-groups/

[v-easonf-msft · Accepted solution]

Hi, @Arnault_ 

Measure1 =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'New Table'[field] ) = "Order lines", [orderlines],
    SELECTEDVALUE ( 'New Table'[field] ) = "Packing lines", [Packing lines],
    SELECTEDVALUE ( 'New Table'[field] ) = "value", [value],
    SELECTEDVALUE ( 'New Table'[field] ) = "volumn", [volumn],
    SELECTEDVALUE ( 'New Table'[field] ) = "weight", [volumn]
)

PowerBI currently does not support setting different data format in one measure ,even if you have set different format for the sub-measure.

Foramtting option "auto" just makes the report automatically adjust for better data display.

As mentioned by @amitchandak ,creating calculation groups using Tabular Editor may be the most likely solution to solve it.

Best Regards,
Community Support Team _ Eason

[Arnault_]

Hi @amitchandak , thanks for you answer. Using calculation group will probably not solve my issue and I don't think it worths the effort. How is this kind of behaviour not automaticaly handled by Power BI? 

[amitchandak · Accepted solution]

@Arnault_ , I think Auto is best option. I think you are using measure slicer, shift in scale might not be soo smooth.

Measure slicer using calculation group might be better option , check - https://www.sqlbi.com/articles/introducing-calculation-groups/