Forum Discussion
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
- Greg_Deckler
Community Champion
Sounds like you need a Sort By column for your month? Maybe a numeric value like 201901, 201812, 201811, 201810, 201809, like that?
Greg_Deckler Unfortunatly it doesn't work the numeric value is 20191 not 201901 :/
v-frfei-msftCommunity 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.
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
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
- 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
