Earliest Date in visual level filter

[Anonymous]

Hi All,

I am trying to filter out the data by top 2 date (Earliest date i.e., jan 1 and jan 2 in below data)

But when i select earliest it is showing up jan 8 data

and when i select latest date then also it is showing jan 8.

Not sure why it is not showing Jan 1 when i select earliest.

Thanks in Advance

Thanks in Advance

[Gordonlilj · Accepted solution]

Hi,

Try filtering with bottom instead of top

[amitchandak]

Check if can do the same with help of rank

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Tara_]

Hi @Anonymous ,

Can you please share the measures Earliest Date and Latest Date so we can understand the issue more. And do you have a seperate Date table in your model?

[Anonymous]

Hi @Tara_ 

I am just dragging and dropping date column to visual level filter as a result it will be showing earliest or latest whatever based on our selection.

Earliest date is Jan 1.

Latest date is Jan 8.

No i dont have date table in my model.

Thanks

[Tara_]

Here are some responses similar to your issue

https://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/td-p/442889

https://community.powerbi.com/t5/Desktop/Top-N-and-EARLIEST-function-in-power-bi/td-p/389439