Forum Discussion

Tine82's avatar
Tine82
Helper I
4 months ago
Solved

Date filters for Visualization

Hi PBI Community,   I have 3 Date filters on one Page , to have the option to Filter by Order Date Delivery Date Loading date For the EndUsers , it is not clear which filter he used and when...
  • grazitti_sapna's avatar
    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!