Forum Discussion

Tine82's avatar
Tine82
Icon for Helper I rankHelper I
6 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...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    6 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!

Tine82's avatar
Tine82
Icon for Helper I rankHelper I
6 months ago

grazitti_sapna , the filter in your Solution does not work correct.
He only filtered by Order date .
We want to select a date field ( Order Date or Delivery Date or Loading Date)  and filter all Data by that selected coloum 

e.g when i set Date filter to 4.4.26
and select Order date = Show Customer E
Select Delivery Date = Show Customer B
Select Loading Date = Show Customer D

do you have here a soloution ?

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
6 months ago

Hi Tine82,

 

Just update this measure and it should work fine. Also attached updated .pbix solution.

 

Sales by Selected Date =
VAR SelectedType = SELECTEDVALUE('Date Type'[Date Type], "Order Date")

RETURN
SWITCH(
    SelectedType,

    "Order Date",
        CALCULATE(
            [Total Sales]
        ),

    "Delivery Date",
        CALCULATE(
            [Total Sales],TREATAS(VALUES('Date'[Date]),Sales[ Delivery Date ]), REMOVEFILTERS('Date'[Date])
        ),

    "Loading Date",
        CALCULATE(
            [Total Sales],
            TREATAS(VALUES('Date'[Date]), Sales[ Loading Date ]), REMOVEFILTERS('Date'[Date])
        )
)
  • Tine82's avatar
    Tine82
    Icon for Helper I rankHelper I
    6 months ago

    grazitti_sapna  thanks for your quick reply, but the solution does not work for my data.
     The filter works only for "Bestelldatum_date"
    Can you please have a look into and check what I did wrong and send the corrected PBI back ?
    How can i add my PBI Version here ?


    Thank you so much and greetings from germany

    Tine82

     

     

     

     

    • grazitti_sapna's avatar
      grazitti_sapna
      Icon for Super User rankSuper User
      6 months ago

      Hi Tine82,

       

      The .pnix i provided earlier is filtering the data as per the date selection, I am not sure how you are doing it, would be better if you can share your version so i can take a look, or if you can share the sample dataset so that i can create a version with you sample data. 

       

      you cannot directly attach it to a post. Instead, upload the file to a cloud storage service (such as Onedrive, Google Drive, or Dropbox), ensure the link is shared publicly, and paste the URL into your post.

      • Tine82's avatar
        Tine82
        Icon for Helper I rankHelper I
        6 months ago

        Hi grazitti_sapna ,
        here are our data.
        When i select "Liefertermin_date" and Date on 20.4  the report shows only Orders with Bestelldatum 20.4. But we expected all Orders with Liefertermin 20.4 because filter is on Liefertermin

        Thanks

        Sales_OrgDistr_ChCMLevel1CMLevel2KundeKundenauftragsnrBestelldatum_dateVerladetermin_dateLiefertermin_dateArtikelBestellmenge_ITLiefermenge_ITBestellmenge_PalLiefermenge_PalBestellwert_GIV
        DE50Test DEKunde 2Kunde 2785214/15/20264/17/20264/19/2026A20202215733.52
        DE50Test DEKunde 2Kunde 2978544/15/20264/17/20264/19/2026C20202210012.24
        DE50Test DEKunde 5Kunde 535974/20/20264/22/20264/24/2026C1001015733.52
        DE50Test DEKunde 2Kunde 2894734/17/20264/19/20264/21/2026A30103110012.24
        CH50Test CHKunde 1Kunde 1123454/16/20264/18/20264/20/2026A10510.510000
        CH50Test CHKunde 1Kunde 1123454/16/20264/18/20264/20/2026B3030336436.44
        CH50Test CHKunde 1Kunde 1123454/16/20264/18/20264/20/2026C20202210012.24
        CH50Test CHKunde 4Kunde 421484/11/20264/13/20264/15/2026B10510.5125974
        AT50Test ATKunde 3Kunde 3987414/10/20264/12/20264/14/2026B3030336436.44
        AT50Test ATKunde 6Kunde 687434/11/20264/13/20264/15/2026A2020226436.44