Changing the X-axis

[Tijevancasteren]

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,

[Aolie]

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

ID	FirstStart	FirstDuration	Duration_Sub1	CurrentDuration
00628000005VtBtAAK	10/07/1986	1280	1173	0
00628000005V1l9AAC	10/10/1984	2615	0	4455
00628000005VtBzAAK	5/08/1985	3878	1451	0
00628000005VtC0AAK	1/05/1985	3284	2232	0
00628000005VtC1AAK	21/03/2000	497	3174	0
00628000005VtBxAAK	31/03/1999	3393	0	0

[MFelix]

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]

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

[richbenmintz]

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.

[Aolie]

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

[Tijevancasteren · Accepted solution]

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

[MFelix]

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