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 ,

 

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mwegener 

This may be a dumn question, but how do you create the Value column in your query table?

 

Thank you!
Sarah

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    The Value column is a simply entered column at my sample data.

    I use the "Enter data" Option to create simple tables direct in Power BI Desktop.