Forum Discussion
Earliest Date in visual level filter
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
Hi,
Try filtering with bottom instead of top
5 Replies
Hi,
Try filtering with bottom instead of top
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?
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
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
