Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    Try filtering with bottom instead of top

     

Tara_'s avatar
Tara_
Icon for Helper II rankHelper II
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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