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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI sacheu,

        These are dax expression which works on power bi desktop, if you directly upload your excel sheet to the power side as the source to create the report, you can't use these expressions. 

        Power bi service does not support these edit features of calculated fields, please design your report on power bi desktop side and you will find the formula bar.

        Comparing Power BI Desktop and the Power BI service 

        Regards,

        Xiaoxin Sheng