𝐒𝐜𝐚𝐭𝐭𝐞𝐫 𝐂𝐡𝐚𝐫𝐭 𝐗-𝐚𝐱𝐢𝐬 𝐝𝐢𝐬𝐩𝐥𝐚𝐲 𝐮𝐧𝐢𝐭𝐬 𝐢𝐬𝐬𝐮𝐞.

[suparnababu8]

Hi Fabric Community,

I am facing a problem with scatter chart x axis display units.

as shown in above image, x-axis display units displaying bnn insted of 20bn,30b,,etc. 
I used the following DAX measure ans set the formating settings to Dynamic Formatting and I set x-axis display units option to Auto. 

VAR SALES= [SALES]
RETURN
SWITCH(TRUE(),
SALES<100000,"0",
SALES<1000000,"#,.0K",
SALES<1000000000,"#,,.0Mn",
SALES>=1000000000,"#,,,.0Bn")

If suppose I set x-axis display units option to None then x-axis display units showing like below

Ideally x-axis shoudl display 10Bn,20Bn,etc...

Can any one pls hel me on this.

Thanks in advance.

@parry2k  whiskeybravo91 @FrossiREAL  @Greg_Deckler @cstenz @v-kmc  @v-mosht @v-angzheng-msft @Sri @SritejaGolla  @ebeery @v-zhouwen-msft @Ritaf1983 

[suparnababu8]

Hi Super User's,

can any one help me on this?

Thanks!!

[suparnababu8]

Hi Experts

Can somone help me on this?

Thanks in advance.

[suparnababu8]

Thanks🙂 for your reply Stephen. But, I want to make it as Dynamic according to filter conditions. That's where I written a dynamic format measure (as mentioned in my 1st message) and used Format as Dynamic. Requesting you pls help me on this. 

[v-stephen-msft]

Hi @suparnababu8 ,

Thanks for reaching out to our community.

If you want to display 10Bn,20Bn, etc, you can directly change the display units from x-axis.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.