Forum Discussion

pravkan's avatar
pravkan
Frequent Visitor
4 years ago
Solved

filter visual by previous day

I have build a dashboard in power bi desktop and I want the visual highlighted in yellow to be filtered by previous day. Example if I chose 4th Aug in the slicer it should display sales data for 3rd...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, pravkan ;

    You could try it,

     

    previous day = CALCULATE(SUM([ Sales]),PREVIOUSDAY('financials'[Date]),ALLEXCEPT(financials,financials[Product]))

     

    I create a simple test file. we could find the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, pravkan ;

You could try it,

 

previous day = CALCULATE(SUM([ Sales]),PREVIOUSDAY('financials'[Date]),ALLEXCEPT(financials,financials[Product]))

 

I create a simple test file. we could find the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.