Forum Discussion

theferret's avatar
theferret
Frequent Visitor
4 years ago
Solved

Odd filter behaviour on a column in data view

I am struggling to understand why the date filter on one of my columns is producing odd results   For some reason I can add photos so this may not make sense   My date filter is on or after 16/7/...
Need Help
  • theferret's avatar
    theferret
    4 years ago

    Well just updated my version of powerbi and it is now working normally. How strange. Thanks for trying to help

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

You can add a photo using the icon:

Also works in data view

theferret's avatar
theferret
Frequent Visitor
4 years ago

Wont let me click done after  I select the photo

 

so if you do equals 4/1/22 you get a result?

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Equals 4/01/2022

     

     

    (As regards the photo, it could be due to wrong file type or size)

     

    • theferret's avatar
      theferret
      Frequent Visitor
      4 years ago

      Well just updated my version of powerbi and it is now working normally. How strange. Thanks for trying to help

  • theferret's avatar
    theferret
    Frequent Visitor
    4 years ago

    So I did what you did with a new pbix and created a small table and works fine, but not in any of my models

     

    i tried 28/2 wondering if it was something t odo with UTC time as I'm in the UK but same issue.  These are all datetime fields, but one modelis coming form MS Dynmaics and the other is from an excel spreadhseet.  Fields are formatted as dates in Power Query.

     

    i tried loading one of the excel sheets up in anew model formatting one field as a date and does exactly the same thing.  Attached is a cut down version with just 2 columns with the pbix

     

    excel 

     

    pbix 

     

    If I filter this for a data i can see I get nothing. ???