Top 5 year

[Bakhtawar]

Hi all

I am trying to get top 5 year from field .. for this i select TOP N and write 5 but this shows me like this

2011

2014

2015

2016

2017

2013 is disappear

check picture

But when i write 8 or 10 then 2013 year appears check image

how i get 2013 in top 5 ?

[v-xicai]

Hi  @Bakhtawar  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Bakhtawar ,

You may put the related 'calendar table'[Date] instead 'fact table'[CLM_INTM_YEAR] into box under "By value" option.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Bakhtawar ,

Please check the Data type of the column , Make sure it is In number format.

Thanks,

RSD

[Bakhtawar]

yes this is in whole number format

[amitchandak]

When you use Top 5 , it based on Measure or value and filter will happen based on that. To display 5 year, you can sort on year and restrict the records to 5

[AnkitBI]

Hi @Bakhtawar 

That's an intersting issue that even I was not aware of. I have done some finding, it seems the issue is because when you use CLM_ITIM_YEAR in "By Value", the system is checking for aggregate value SUM(CLM_ITIM_YEAR) in table instead of individual value like 2012,2013,2014 etc. Hence, Top 5 CLM_ITIM_YEAR are returned excluding 2013.

Please check below post for detailed information.

https://community.powerbi.com/t5/Desktop/Bug-in-the-top-N-function/td-p/225987

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.