Forum Discussion

Tijevancasteren's avatar
Tijevancasteren
Regular Visitor
9 years ago
Solved

Changing the X-axis

Hi all,

I have two quick questions about my X-axis.

 

I can't to get the values on the axis to display without decimals. I have 4 other charts like this with other values and the X-axises are without decimals there.

 

 

The chart above displays 5 averages. I would like the bars to be spaced, just like the chart above this one. How can I do this? I would really appreciate the help!

Best regards,

Need Help
  • Tijevancasteren's avatar
    Tijevancasteren
    9 years ago

    Thanks for the answers! I see that my question is not correct. With the decimals I meant the labels on the x-axis, beneath the bars. Now they are 1.0, 2.0, 3.0, 4.0 and 5.0. I want them to be 1, 2, 3, 4 and 5. I will look into it!

    Thanks

7 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi Tijevancasteren,

     

    1st Question:

    In the options for your chart if the  values are formated as Number you should be able to define the Decimal units by default it as Auto but you can place 0. Please be aware if you values for the X-Axis are formated as Text this option won't be available.

     

    2nd question:

    Instead of placing the description in the Legend you should place it in the X-Axis and then you will get the chart above.

     

    Regards,

    MFelix

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    9 years ago

    Issue 1:

    -  the labels on the x axis are members of a table and are displayed as labels, you would have to change the formatting of the data to have it display without the decimals.

     

    Issue 2: 

    - I do not think this is possible with the current column chart, I have not found a property that allows you to add a padding between bars.

     

     

     

    • Tijevancasteren's avatar
      Tijevancasteren
      Regular Visitor
      9 years ago

      Thanks for the answers! I see that my question is not correct. With the decimals I meant the labels on the x-axis, beneath the bars. Now they are 1.0, 2.0, 3.0, 4.0 and 5.0. I want them to be 1, 2, 3, 4 and 5. I will look into it!

      Thanks

    • Aolie's avatar
      Aolie
      Regular Visitor
      8 years ago

      Hi Felix,

      I sent a sample of what I am trying to achive. I got your explanation but if there is a work around to this I will appreciate you guide me. In Excel I can do achive it but I need to share the report to use through power bi.

       

      Thanks

  • Aolie's avatar
    Aolie
    Regular Visitor
    8 years ago

    I have a related issue below that I also need help

     

    I have the data below, I want the ID in Y axis and Date as X axis .

    The value of FirstDuration, Duration_Sub1 and  CurrentDuration should be a stack bar.

    Kindly help or advice me on waht to do.

    Thank you

     

    IDFirstStartFirstDurationDuration_Sub1CurrentDuration
    00628000005VtBtAAK10/07/1986128011730
    00628000005V1l9AAC10/10/1984261504455
    00628000005VtBzAAK5/08/1985387814510
    00628000005VtC0AAK1/05/1985328422320
    00628000005VtC1AAK21/03/200049731740
    00628000005VtBxAAK31/03/1999339300
    • MFelix's avatar
      MFelix
      Super User
      8 years ago

      Hi Aolie,

       

      What is the type of information you want to show, because it's incompatible to show first data on x-axis and ID on Y-axis.

       

      No reaaly getting what do you intend on getting with this information, Why don't you do a hierarchy within your x-axis between start and ID?

       

      Regards,

      MFelix

      • Aolie's avatar
        Aolie
        Regular Visitor
        8 years ago

         

        Hi Felix,

        Below is what I am trying to achive but instead of % on X axis I want date value.

         

        Thank you

        Sample- instead of % I want date