Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
@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 !!! |
Here is the link of the file with very few data but might work to provide solution.
Thank you so much 🙂
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.
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 !!! |
I did the same but when I use slicer filters I did'nt bring any filtered data 😞
Can you share your pbix file ? what is the type of Created Date On initially ?
Here is the table information.
Let me know if I created wrong date table
Not in the calendar in the other tables ?
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.
Can you please share your pbix file ?
Here is the link of the file with very few data but might work to provide solution.
Thank you so much 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
132 | |
101 | |
95 |