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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

kpi indicator - displaying by month

Hi,

 

I use the "KPI Indicator" visualization and I am not able to display the curve behind correctly by month.

 

My firt try was to put a date into "trend axis" but there is to much points as it takes the whole date. When I use the hierachy I can only display it by year.

 

So I decide to extract month and year. But it sorts the trend axis like this 10 1 11 12 (month number).

 

Any idea to proceed please ?

 

Thanks

7 REPLIES 7
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

To update the formula of yours as below.

 

 

Month = YEAR('sample'[END_DATE_UT])*100+MONTH('sample'[END_DATE_UT])

 

Then we can sort the Month column as we need.

 

Capture.PNG

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable
Anonymous
Not applicable

Any idea ?

v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

How about changing the sort by this way. We can make the month column to be sorted by the date column in Modeling pane.

 

Capture.PNG

 

If it doesn't meet your requirement, kindly share your sample data to me. Please upload your files to One Drive and share the link here.

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Hi @v-frfei-msft,

 

It doesn't work as well. It displays month in this order : 10 1 11 12

 

I will try to make you a sample.

 

Thanks

Greg_Deckler
Super User
Super User

Sounds like you need a Sort By column for your month? Maybe a numeric value like 201901, 201812, 201811, 201810, 201809, like that?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler Unfortunatly it doesn't work the numeric value is   20191 not 201901 😕

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.