Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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
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 |
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi Felix,
Below is what I am trying to achive but instead of % on X axis I want date value.
Thank you
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.
Proud to be a Super User!
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
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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
90 | |
73 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |