Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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