Forum Discussion

sacheu's avatar
sacheu
Microsoft Employee
5 years ago
Solved

How to create a date slicer for 2 data fields

Hi,   In my PowerBI page, I have 2 widgets with 2 different tables. Both tables have a column 'date'. I want to create 1 'data slicer' so that when I change the range of the date, both widgets wil...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sacheu,

    Please take a look at the following link to know how to find out the root file link of files stored on a cloud server, then you can use power bi desktop to get data from the online file directly:

    Use OneDrive for Business links in Power BI Desktop 
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI sacheu,

You can try to extract the date values from two tables to create a calendar, that you can use this as the bridge to link to tables.
After these steps, you can use bridge calendar to create a slicer and it will apply filter effects to two table records.

Regards,

Xiaoxin Sheng

  • sacheu's avatar
    sacheu
    Microsoft Employee
    5 years ago

    Thanks. How can I create a calendar from 2 tables?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi sacheu,

      You can try this calculate table formula if it works on your side:

      New Table =
VAR _list =
    UNION ( ALL ( Table1[Date] ), ALL ( Table2[Date] ) )
RETURN
    CALENDAR ( MINX ( _list, [Date] ), MAXX ( _list, [Date] ) )

      Regards,

      Xiaoxin Sheng

      • sacheu's avatar
        sacheu
        Microsoft Employee
        5 years ago

        I am using an Excel spreadsheet online as the data source of my PowerBI report. In this setting, I don't see a way which let me enter the above formula  in the report.