Forum Discussion

JoseDavid's avatar
JoseDavid
Icon for Helper I rankHelper I
8 years ago
Solved

It´s possible create a double filter?

I´d like to know if it is possible create a double filter in Power Bi.

 

For example, a year filter wich filter the years of a table 1 and the years of the table 2

 

I think it could be very difficult, but I have thought it could be possible with the funtion "filter", but I´m not a developer and it´s too much for mee.

 

Any help?

 

Thanks very much!!!

 

jd

  • sokg's avatar
    sokg
    8 years ago

    Where is your calendar table???

     

    You must use one and create relationships to forecast and sales and then use the year column from the calendar only as a slicer.

    This will flow the filter from the calendar to forecast and sales tables.

8 Replies

    • JoseDavid's avatar
      JoseDavid
      Icon for Helper I rankHelper I

      I tried, but i do not get unite the different dates, becouse one of them are blling dates and the other it´s forecast dates......

       

      I can incorporate this dates in de calendar table, but nothing else

      • sokg's avatar
        sokg
        Icon for Solution Supplier rankSolution Supplier

        Can you provide us sample data???