kpi indicator - displaying by month

[Anonymous]

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

[v-frfei-msft]

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.

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

https://www.dropbox.com/s/b8ifia81qgnkrre/example.pbix?dl=0

[Anonymous]

Any idea ?

[v-frfei-msft]

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.

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

[Anonymous]

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]

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

[Anonymous]

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