Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use Same Filter for Multiple Columns

Hi,   I was wondering if there was a way to create a slicer for the same month and day, but used for different columns in a table. In my table, there are two different dates. One for Inititated Mo...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    I have created a small example.

     

    With USERELATIONSHIP you can switch the relationship for a measure.

    https://docs.microsoft.com/en-us/dax/userelationship-function-dax

    You may download my PBIX file from here.
    Hope this helps.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

could you share a screenshot of your model view?

Is there only one Measure in your Matrix?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Good Morning mwegener !

I am new to Power BI... is this what you mean for model view?

 

The original table with Init Month and Day and Repaired Month and Day are in the Query1 table... I have been trying to play around and created the Datess, Dates, and Slicer tables and have tried linking them, but I cannot seem to create the correct link so that my filter filters for both Init and Repaired Month and Day...

 

Thank you so much!
Sarah