Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to filter based on an input date

Hello,   I would like to filter my data based on a date input. Create a slider like to determine a day in the month and use that value inside of measures. How could I create that (the input & the ...
Need Help
Tutorial Requests
Jeanxyz's avatar
Jeanxyz
Power Participant
4 years ago

Do you have a column called 'input date' in the input table? If that's the case, you can create a dim_calendar table and link the input table to dim_calendar table based on relationship dim_calendar [date] - fact_input[input date]. 

 

You can then add a slicer to the visual, drag and drop dim_calendar[date] to the slicer. 

 

pbix sample: https://www.dropbox.com/s/8nzzp6mxlt4871x/filter%20test.pbix?dl=0

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I do have 2 dates columns that I want to filter, but I want to filter both of them but only the day.

    Would there be any way to do it ?

    • Jeanxyz's avatar
      Jeanxyz
      Power Participant
      4 years ago

      @fzpokg, Are both columns in the same table?  It's not a typical solution, but you can link both date columns to dim_calendar table, but Power BI only allows one active relationship, the other one will be inactive. You can enable the inactive relationship via userelationship(). 

       

      Here is DAX guide on userelationship()

      https://dax.guide/userelationship/

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Both are in the same Table, but I would like to be able to use the day number to filter on another table.