CODEWITHSUNDEEP
powerbi
user12811294
user12811294

Reputation: 1

Showing October 2020 as Oct 2020 on the X axis of PowerBI Chart

I have a PowerBI Chart that I am working on for which. I got the Bars Chart on the X axis and the value for each bar in the chart is Month and Year. It is showing full months name like October 2020 but my business user wants to see OCT 2020 instead of October 2020.

enter image description here

Please help me how to change it

Thanks

Upvotes: 0

Views: 34

Answers (2)

Sai
Sai

Reputation: 61

Go to Transform data and add a column to your table with the following formula

your_new_shortname = Format (Table[Date], "mmm")

Use this new column in your visualization.

Upvotes: 0

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89386

Add a calculated column on your date table and set its Sort By Column.

Upvotes: 0

Related Questions