Forum Discussion

stfox's avatar
stfox
Helper I
9 years ago
Solved

Creating a Universal filter that acts on two columns

Hi Folks I want to create a  single "universal" Year-Month  filter that will act on two different Date columns ( "Enrolment Date", and "Exit date") and the measures that flow from each of them.   ...
Need Help
  • stfox's avatar
    stfox
    9 years ago

    Thanks Lydia, Ankitpatira,

    I think as a work around I will restructure the dataset in PowerQuery, so that I have a single "Date" column, and then an additional column ("Type of Date") that classifys what sort of date it is (enrollment or exit etc) as shown in the screenshots below.  This then allows me to use the date column as a "universal filter (Gneric_Month_Year). 

     

    Working Example pbix file is available here

     

    Thanks again for your input on this.


    Cheers

    Steve

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi stfox,

Based on my test, we are not able to set a parameter in your scenario to filter the two visuals at the same time as the two date columns locate in a single table. If you want to utilize parameter, you would need to duplicate your table keep date columns in two different tables. For more details about how to work with query parameter in Power BI Desktop, you can review the following blogs.

POWER BI DESKTOP QUERY PARAMETERS, PART 1

Query Parameters in Power Query – Part 1

Moreover, I agree with ankitpatira. I can’t think of other methods except this method that create relationship between date table and both the queries for dates.

Thanks,
Lydia Zhang

stfox's avatar
stfox
Helper I
9 years ago

Thanks Lydia, Ankitpatira,

I think as a work around I will restructure the dataset in PowerQuery, so that I have a single "Date" column, and then an additional column ("Type of Date") that classifys what sort of date it is (enrollment or exit etc) as shown in the screenshots below.  This then allows me to use the date column as a "universal filter (Gneric_Month_Year). 

 

Working Example pbix file is available here

 

Thanks again for your input on this.


Cheers

Steve