Forum Discussion

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago

Override slicer for specific visual

Hi,

 

I have a card visual with a measure value which can be changed by a slicer between previous day, week to date, month to date etc.. and I have other visuals that show the same measure but in different ways.

What I want is for my card visual to default to week to date if a user selects day from the slicer but the other visuals to work as normal. 

Is this possible without having to create duplicate measures just for the card?

 

Thanks,

 

Ben

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Ben81 , Try measures like

     

    WTD based on the selected date or today

     

    WTD =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = _max -WEEKDAY(_max,2)+1
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

     

    WTD of full data

    WTD =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = _max -WEEKDAY(_max,2)+1
    return
     if(isfiltered('Date'), CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max)), [net])

     

    where [net] is my measure