Forum Discussion

ktg2019's avatar
ktg2019
Frequent Visitor
1 year ago
Solved

Removing a slicer interaction while still using the slicer value

In my report, a user will select a date using a date between slicer and we're only using the minimum date selected.

 

This date can be any day of the week. I want to show the sales numbers for the entirety of that week. For example, if a user selects a Wednesday, I want to show the values for Sunday through Saturday of that week. 

 

I have tried several remedies, but it seems like I either show the days leading up to the selected day or the days after the selected day-- I have not been able to see the entire week at once. 

 

One attempt of a calculation was 

CALCULATE(sum(*redacted sales table info*),ALL('vw_D_Date'[date_value]),FILTER(*redacted sales table*,[MinimumSelectedDate]))
 
where MinimumSelectedDate = FIRSTDATE('vw_D_Date'[date_value])

 

Any suggestions on how to solve this? 

date calculations
date ranges
DAX
powerbi
slicer interactions
slicers
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, ktg2019 

    You can try the following method to achieve your need.

     

    Measure:

     

    Sales = 
VAR _quarterSlicer = SELECTEDVALUE(Slicer[Quarter])
VAR _quarterSales = SELECTEDVALUE(Sales[Quarter])
VAR _yearSlicer = SELECTEDVALUE(Slicer[Year])
VAR _yearSales = SELECTEDVALUE(Sales[Year])

VAR _result = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,_yearSales = _yearSlicer && _quarterSales = _quarterSlicer ))
RETURN
IF(_yearSales = _yearSlicer && _quarterSales = _quarterSlicer,1)

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, ktg2019 

    You can try the following method to achieve your need.

     

    Measure:

     

    Sales = 
VAR _quarterSlicer = SELECTEDVALUE(Slicer[Quarter])
VAR _quarterSales = SELECTEDVALUE(Sales[Quarter])
VAR _yearSlicer = SELECTEDVALUE(Slicer[Year])
VAR _yearSales = SELECTEDVALUE(Sales[Year])

VAR _result = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,_yearSales = _yearSlicer && _quarterSales = _quarterSlicer ))
RETURN
IF(_yearSales = _yearSlicer && _quarterSales = _quarterSlicer,1)

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • sjoerdvn's avatar
    sjoerdvn
    Solution Sage
    1 year ago

    Why not create a slicer with week numbers? Just add a column to your date dimension with year and weeknumber. You could also create a column for your slicer that includes the dates e.g "2025 WK1 (30-12-2024 - 05-01-2025).