Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Adding filter via code to an existing table on desktop - how?

I have an existing table that I created by clicking on a table visualisation, then manually dropped a measure and dimension columns into it.    I would like to add a date filter via a custom measur...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous You can try by creating a measure using SELECTEDVALUE to capture the slicer date (e.g., SelectedDate = SELECTEDVALUE('DateTable'[Date])). Then, create another measure to filter rows, such as FilteredTable = IF(MAX('YourTable'[DateColumn]) = [SelectedDate], 1, 0). Add this measure to the table visual’s filters pane and set it to is 1.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi Anonymous You can try by creating a measure using SELECTEDVALUE to capture the slicer date (e.g., SelectedDate = SELECTEDVALUE('DateTable'[Date])). Then, create another measure to filter rows, such as FilteredTable = IF(MAX('YourTable'[DateColumn]) = [SelectedDate], 1, 0). Add this measure to the table visual’s filters pane and set it to is 1.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, thank you for your help.

     

    My slicer has an output of 4 ( the month of april ), which i have confirmed is correct

    I get my [month behind] using this measure :    [month behind] = SELECTEDVALUE('Calendar'[Month]) -1

    which gives value of 3 ( month of march )
    When I drag and drop [month behind] onto the desktop , I see a value of 3, so that is OK.
     
    When I create this new measure :
    FilteredTable = IF(MAX('Calendar'[Month]) = [month behind], 1, 0)
    and set it to 1 as you suggested, unfortunately I get no data unfortunately ( the output is blank ).

     

    Not sure why ?