Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Making card into filter

I have a card that calculates a count of how many times "call back" is entered in my SharePoint list under the column "Request Type" from the previous month.  The measure is as follows:

 

"count of call back requests for the previous month": CALCULATE(COUNT('TableName'[RequestType]), MONTH(Date) = MONTH(Today()) - 1, 'TableName'[RequestType] = "Call back")

 

I want to make it so that when I click the card,  it will filter my table to show the line items containing call back from the previous month.

 

Is that possible and if so, how can I make the card do this? 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    no, not possible. Measures cannot drive slicers.  They can drive visual level filters though...

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Instea of clicking on the card, why do you not create a slicer of month and select a month there.  The slicer should be built from the Month name column of the Calendar Table.  You should create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number.  To your visuals/slicer, drag Year and Month name column from the Calendar Table.  Select a year and Month name.  Create a relationship (Many to One and Single) from the Date column in your TableName table to the Date column of the Calendar Table.  Write these measures:

    Number of call backs = CALCULATE(COUNT('TableName'[RequestType]),'TableName'[RequestType] = "Call back")

    Number of call backs in PM = calculate([Number of call backs],previousmonth(calendar[date]))

    Hope this helps.