Forum Discussion
Date filters for Visualization
Hi Tine82 ,
Instead of creating separate slicers for all dates, I've used a single date from Date table.
I've also created a separate date type table to use that in a slicer. now user can see the data by filtering date type from slicer. also check the measure "Sales by Selected Date" which is considering the date type selected.
See attached .pbix file, let me know if this is the solution you are looking for.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Hi Tine82,
I've tested with the sample data and it's working fine for me (See Attached File)
Make sure that the relation is active and date table is filtering your fact table
Please see if there's any active page/visual/report level filter applied
there are no bookmarks which can impact the visual
Make sure you've updated Date type table with correct values
points to be considerd-
Make sure you've active one to many relatsionship with Bestelldatum_date
We do not need selected filter label measure, that was just for testing.
We need total Bestellemenge IT as we are using it in our final measure "Sales By Selected Date"
Hope this helps, let me know what did you miss? I assume issuw is with your Date Type table which is not updated with correct values.
grazitti_sapna thanks for yout time, but it does not work.
When i add all field into the Table he show wrong Data ( see screen below) -i uses your attached solution pbix from today
Regards, Tine82
Ok Tine82,
I got the issue, you can not add a column directly to the table view because it breaks the logic which we have created in the measure, you need to replicate the same whle calculating "
sum of Bestellmenge_Pal" to keep the logic intact, Please see attached .pbix file, I've added another meaure and it works fine.