Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
zarmonas
Frequent Visitor

KPI Visual Shows December as last month when Dec 2022 & Jan 2023 & Feb 2023 is selected

‎02-23-2023 12:24 AM

So the title says it all.
I would like to see data in KPI of Dec 2022 - Feb 2023, but whenever December is selected, it appears as a last month.
Is there a way to to see current month as a last month, even when previous year's December is selected?

Thanks in advance.

example.PNG

Labels:
Message 1 of 3
661 Views
0
1 ACCEPTED SOLUTION
AlexanderPrime
Solution Supplier
Solution Supplier

‎02-23-2023 01:15 AM

Easiest way is to make a concat column for Year-Month (So December 2022 would appear as 2022-12), then set the visual to display using that new column as the Date axis. 

As Feb 2023 selected would result in the following order:

2022-12

2023-01

2023-02


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

View solution in original post

Message 2 of 3
646 Views
2 REPLIES 2
AlexanderPrime
Solution Supplier
Solution Supplier

‎02-23-2023 01:15 AM

Easiest way is to make a concat column for Year-Month (So December 2022 would appear as 2022-12), then set the visual to display using that new column as the Date axis. 

As Feb 2023 selected would result in the following order:

2022-12

2023-01

2023-02


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!
Message 2 of 3
647 Views
zarmonas
Frequent Visitor
In response to AlexanderPrime

‎02-23-2023 11:29 PM

Thank you, worked like a charm.

Message 3 of 3
599 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All