Filter data as per slicer without timestamp properties

[TejasShah]

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
3	2245	103	418	1609	3	37
4	2237	77	463	943	35	105
5	1863	92	765	901	26	21
6	2453	93	835
7	2334	88	0
8	2731	58	718
9	1255	112	1017

Which has been transformed to below when loaded into PowerBI :

Month	Attribute	Day	MonthNum	Value
January	Bus	1	1	69
January	Bus	2	1	29
January	Bus	3	1	103
January	Bus	4	1	77
January	Bus	5	1	92
January	Bus	6	1	93
January	Bus	7	1	88
January	Bus	8	1	58
January	Bus	9	1	112
January	Car	1	1	1507
January	Car	2	1	2761
January	Car	3	1	2245
January	Car	4	1	2237
January	Car	5	1	1863
January	Car	6	1	2453
January	Car	7	1	2334
January	Car	8	1	2731
January	Car	9	1	1255
January	Trucks	1	1	0
January	Trucks	2	1	618
January	Trucks	3	1	418
January	Trucks	4	1	463
January	Trucks	5	1	765
January	Trucks	6	1	835
January	Trucks	7	1	0
January	Trucks	8	1	718
January	Trucks	9	1	1017
February	Bus	1	2	43
February	Bus	2	2	21
February	Bus	3	2	3
February	Bus	4	2	35
February	Bus	5	2	26
February	Car	1	2	730
February	Car	2	2	1024
February	Car	3	2	1609
February	Car	4	2	943
February	Car	5	2	901
February	Trucks	1	2	100
February	Trucks	2	2	79
February	Trucks	3	2	37
February	Trucks	4	2	105
February	Trucks	5	2	21

I have my maximum data with timestamp, so I am using a slicer with timestamp properties, where as my excel sheet data just has Day and Month as my Slicer properties.

And if I select just the dates of February from the Slicer, I still get those days from January as well:

Requesting someone to please guide me through, I have also formed the relationship of Many to Many with Excel table(Day) with the other table with timestamp(Day).

[v-xuxinyi-msft]

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]

Thank you @v-xuxinyi-msft , 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.

[AndrewPF · Accepted solution]

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". 

[TejasShah]

Thank you @AndrewPF , this worked well! I just couldn't think of that solution while I was stuck with my visuals, thank you!