Forum Discussion

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

๐’๐œ๐š๐ญ๐ญ๐ž๐ซ ๐‚๐ก๐š๐ซ๐ญ ๐—-๐š๐ฑ๐ข๐ฌ ๐๐ข๐ฌ๐ฉ๐ฅ๐š๐ฒ ๐ฎ๐ง๐ข๐ญ๐ฌ ๐ข๐ฌ๐ฌ๐ฎ๐ž.

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 Anonymous  v-mosht v-angzheng-msft Sri SritejaGolla  Anonymous Anonymous Ritaf1983 

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

  • suparnababu8's avatar
    suparnababu8
    Icon for Super User rankSuper User
    2 years ago

    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.