Forum Discussion

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
8 years ago

Select Weekly Period and slice use's dates on report

Hello I have a table that has week numbers and the dates for these weeks, it look like the image.   What I want to do is present the user the Week_Number in a slicer and then the report of my ...
GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
8 years ago

Hello Angelia

I have followed your steps, but it has not applied a filter to my data, it just gives a date for the week I have selected.

 

What I want is it to remove all data that is not in my selection, from the slicer.

 

 

I'm not ready to try this on my sales data, so I tried to apply it to my stock data insted and it to filter the order_due date.  Order_Due_N is my measure.  I was expecting to only see the top line but as you can see there are other line in my report.

 

Can you tell me what I am doing wrong?

 

Regards

 

GrahamR99

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi GrahamR99,

Got it, it seems like your scenario is different from mine. Could you please share your .pbix file for further analysis?

Best Regards,
Angelia

  • GrahamR99's avatar
    GrahamR99
    Icon for Resolver I rankResolver I
    8 years ago

    Hello Angelia

    I don't want to upload my .pbix as it contain sensitive data. Is there another way we can get to what I need?

     

    Regards

     

    GrahamR99

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi GrahamR99,

      You can share the sample data by private message.

      Best Regards,
      Angelia

      • GrahamR99's avatar
        GrahamR99
        Icon for Resolver I rankResolver I
        8 years ago

        Hello Angelia

        How do I send you my Power BI file in a Private Message?

         

        Regards

         

        GrahamR99