Forum Discussion
Date filters for Visualization
- 4 months ago
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 checked this solution again and it's working fine for me.
Please check above mentioned steps if it's not working for you.
Hello @grazitti_sapna and thanks for you massage, but your Solution does not work โน๏ธ
When you add the other fields into the table, the Filter is not working correct.
(see picture below: i selected "Liefertermin" and as Date "20.4" he show also Liefertermin 24.4 and the Quantitys are empty)