Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer For Two Different Date Columns

Hey, there I am looking to create a sing slicer that will slice two different date columns. I have data on jobs that come in which have a created date and a resolved date which are the main dates of ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi thanks for the quick reply. I tried that and it messes up the dashboard.

 

I created a date table using the following code 

Date = CALENDAR(MIN(JIRA_ISSUES_REPORTING_CA[Created Date]), TODAY())
 
And inputted the relationships like so 
 
 

 

However it messes with the dashboard and breaks a lot of it. Is there any other alternatives or ways around this? It breaks the dashboard even when they are both inactive.

 

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , Anonymous 

    Once you create an inactive relationship, it means that when you want to use the inactive relationship to filter  any field in the visualization, you need to create a new measure to replace it (see measue "End date2" in pbix file) .

    Here is a sample file.

    Pbix attached

     

    Best Regards,
    Community Support Team _ Eason