Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

Trick for value too big

Hello guys,

 

Looking for idea or trick, let say in a column chart of months, when we have data value which is too big in particular month only, is there a way to make it more nice visibility, but still not loosing the scale of one another.

 

Take example below:

The value on Oct 2020 indeed very big, 2.5M compare with other months which is only 15,000 or 22,000, but still because it's too small, it is hard to recognize that actually we has some "movement" in months other than Oct 2020.

 

Any trick to make it more visible or nicer to look.

 

Thanks.

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi admin_xlsior ,

     

    Yes. You cannot use "log" option if there are some values that less than or equal to 0 in the field.

    Values are all positive.

    Changing the scale type from "linear" to "log" is a method to significantly reduce data fluctuations, you could have a try.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

     

8 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey admin_xlsior ,

     

    if you want to change the value you can do that with a measure.Something like:

    MyMeasure = IF ([Measure] > 100000, 100000, [Measure])



    Otherwise you can also limit the y-axis and override the max of the axis:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

    • joannm's avatar
      joannm
      Frequent Visitor
      1 year ago

      "Otherwise you can also limit the y-axis and override the max of the axis:"

      This is what ended up working for me. Even log didn't create a chart that had readable bars for the lower values.

       

      Setting the max value to a value much lower than the one outlier allowed the smaller value columns to be visible and kept the one extremely large column taller than the rest, albeit not proportionally, and with a data label easily understood to be much higher. 

       

      Thanks!

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      5 years ago

      Hi amitchandak ,

       

      Thanks, for the link. So does it mean to say, it cannot be zero or negative to use "Log" ?

      Coz I just read, if it is not > 0 return BLANK()

       

      Thanks,

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, admin_xlsior 

    Please try for the below.

     

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      5 years ago

      Hi Jihwan_Kim ,

       

      I think I like that "Log" one, but I wonder why my selection is only Linear ->

       

      Any thought why ?

       

      Thanks,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi admin_xlsior ,

         

        Yes. You cannot use "log" option if there are some values that less than or equal to 0 in the field.

        Values are all positive.

        Changing the scale type from "linear" to "log" is a method to significantly reduce data fluctuations, you could have a try.

         

        Hope that's what you were looking for.

        Best Regards,

        Yuna

         

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