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.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Make sure the fact table has a proper relationship to the calendar table on a date field.

Use this below mesure:

ShowPreviousMonthRows =

VAR SelectedMonth = SELECTEDVALUE('Calendar'[Month])

VAR TargetMonth = SelectedMonth - 1

VAR RowMonth = MONTH(MAX('Yourtable'[Date])) 

RETURN

    IF(RowMonth = TargetMonth, 1, 0)

 

Add this measure to the filters pane of the table visual and set the filter condition to 1.

This will ensure the table only shows rows from the month prior to the one selected in the slicer.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa