How to filter year and month by slicer on "Created Date On" from 4 different data sets.

[Abdullah-Ultra]

I have 4 different data set and every data set have "Created Date On"

Have to create 4 bar charts one from every data set.

How to create 2 slicers one to filter by Years and one for by months on based of "Created Date On"  ??

Thanks in advance 🙂 

[Anand24]

@Abdullah-Ultra ,
Is the issue resolved? If not, can you make sure all date fields are of Date datatype and not Date/Time.

If still not resolved, please try to attach the report after removing sensitive data so that we can solve and give back the solution pbix.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Abdullah-Ultra]

Here is the link of the file with very few data but might work to provide solution.

Thank you so much 🙂 

https://nuclearsystems-my.sharepoint.com/:u:/g/personal/abdullah_jamil_ncs_group/Edy8j5bhLqZEkGarW2W... 

[AmiraBedh]

It is simple you need to create a calendar table :

 = CALENDAR(DATE(2010,01,01), DATE(2021,12,31))

You need to check the intervals, it returns a single column table with datetime values from the start date to the end date.

Link the calendar table to your existing tables. A hierarchy will be created and you can choose the year and the month in filters.

[Anand24]

Hi @Abdullah-Ultra ,
Create a date dimension table using CALENDAR or CALENDARAUTO and create 4 relationships from this table's date with all 4 "Created Date On" with uni-directional filtering (arrow from Date Table's date towards the 4 "create date on").

In the Year and Month slicers, take the Year and Month from the new date.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Abdullah-Ultra]

I did the same but when I use slicer filters I did'nt bring any filtered data 😞 

[AmiraBedh]

Can you share your pbix file ? what is the type of Created Date On initially ?

[Abdullah-Ultra]

Here is the table information.

Let me know if I created wrong date table

[AmiraBedh]

Not in the calendar in the other tables ?

[Abdullah-Ultra]

Here you go

same in all other data set aswell, data type is date but for your information there is time information in it as well if I change data type from date to date and time so it will show if that might creating any issue as my calander table time is 000000 in against every date.

[AmiraBedh]

Can you please share your pbix file ?

[Abdullah-Ultra]

Here is the link of the file with very few data but might work to provide solution.

Thank you so much 🙂 

https://nuclearsystems-my.sharepoint.com/:u:/g/personal/abdullah_jamil_ncs_group/Edy8j5bhLqZEkGarW2W...