Forum Discussion

TejasShah's avatar
TejasShah
Helper I
2 years ago
Solved

Filter data as per slicer without timestamp properties

I have a table on a spreadsheet with the following data:   Month January February Day Car Bus Trucks Car Bus Trucks 1 1507 69 0 730 43 100 2 2761 29 618 1024 21 79 ...
Tips and Tricks
  • AndrewPF's avatar
    AndrewPF
    2 years ago

    If I have understood the problem properly, then you should be able to resolve this by creating a new date column in Power Query using the day and month already present. 

    Then use this new column in your slicer, and change the settings to a date range, or "between". 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi TejasShah 

 

You can create a measure with if to determine whether the Month, day of the data in the table is the same as the Month, day of the slicer, the same show 1, not the same show 0, and then put the measure into the visual-level filters, set up show items when the value is 1.

 

You can refer to the following link for details on how to do this: 

Solved: I want to show specific year ranges (start year to... - Microsoft Fabric Community

 

If I've misunderstood you, please provide sample data of the Timestamp table: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. We can better understand the problem and help you.

 

Best Regards,
Community Support Team _Yuliax

 

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

TejasShah's avatar
TejasShah
Helper I
2 years ago

Thank you Anonymous , I will surely try out this solution as well, though AndrewPF 's comment was much more a convenient way out, since I already had day & month columns in my data.