Forum Discussion

Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago
Solved

Weird date filter behaviour

I have a table which works out time values.   I am having issues when filtering it based on date, instead of hiding the irrelevant records it shows ::   The column with the time, is using an expr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lakka00 

    In my speculate, there must be some some formatting issue with your [Length] column.

    Please try this measure:

    Measure = 
VAR _len = VALUE(SELECTEDVALUE('Table'[Column1]))
VAR _hour = INT(_len/3600)
VAR _minute = INT(MOD(_len,3600)/60)
VAR _second = MOD(_len,60)
RETURN FORMAT(_hour,"00")&":"&FORMAT(_minute,"00")&":"&FORMAT(_second,"00")

     

    Best Regards

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

foodd's avatar
foodd
Community Champion
2 years ago

Hello Lakka00 , and thank you for sharing a question with the forum.  The following is informational.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!