Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
Solved! Go to Solution.
@HBEN , Refer to these screenshots. or Check power bi part from this video -Bar/Clustered Bar: https://youtu.be/2P5BBRN853c
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |