cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
zarmonas
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
AlexanderPrime
Solution Supplier
Solution Supplier

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

2 REPLIES 2
AlexanderPrime
Solution Supplier
Solution Supplier

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!

Thank you, worked like a charm.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors