Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HBEN
Frequent Visitor

Date on Visual doesn't show year and sort accordingly

Hi,

 

I am doing a visual and I use a calendar/ date slicer. When I select the date slicer to show last 12 months data, it shows 1/12/2020 to 30/11/2021 which is fine, however on the visual Dec 2020 shows after 30/11/2021 which is incorrect. See snip below.

HBEN_0-1638832897077.png

How can I make the power BI recognise that Dec 2020 should show before Jan 2021. How can I make the axis present month in the form as mmm-yy?

 

Many Thanks

1 ACCEPTED SOLUTION

@HBEN , Refer to these screenshots. or Check power bi part from this video -Bar/Clustered Bar: https://youtu.be/2P5BBRN853c

 

Concat 1.pngConcat Label Off.pngConcat2.png

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@HBEN , Unless you add year to visual this will not bet corrected.

 

Add Year on axis. Concatenate label -off , sort on year , Month

Thanks @amitchandak - I didn't quite understand, Can you please explain in a bit more detail?

Thanks

@HBEN , Refer to these screenshots. or Check power bi part from this video -Bar/Clustered Bar: https://youtu.be/2P5BBRN853c

 

Concat 1.pngConcat Label Off.pngConcat2.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.