Forum Discussion
Rich_P_G
Helper I
Helper IX-Axis Duplicating Date
Hello All, I am having a strange issue I haven't encountered before in Power BI Desktop. I have a bar graph with the X-Axis using Dates and the Type set to categorical. I am getting this res...
Hi Rich_P_G
As tested, if the original data is as below
date value 8/1/2019 1 9/1/2019 2 9/2/2019 3 10/1/2019 4 11/1/2019 5 Then in Power BI, change the "type" of "date" column to MMMM YYYY,
select categorical type for X-axis,
To solve this problem, I add a calculated column as below
Column = FORMAT([date],"mmmm yyyy")Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft
Community Support
Community SupportHi Rich_P_G
As tested, if the original data is as below
| date | value |
| 8/1/2019 | 1 |
| 9/1/2019 | 2 |
| 9/2/2019 | 3 |
| 10/1/2019 | 4 |
| 11/1/2019 | 5 |
Then in Power BI, change the "type" of "date" column to MMMM YYYY,
select categorical type for X-axis,
To solve this problem, I add a calculated column as below
Column = FORMAT([date],"mmmm yyyy")
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rich_P_GThis worked. Thank you!