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

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

      • sacheu's avatar
        sacheu
        Microsoft Employee
        5 years ago

        Thanks. But when I use 'Power BI desktop', it does not allow me to use and Online Excel spreadsheet as the data source of my report. The excel spreadsheet needs to be Online since it is periodically getting updates. I only let me import a local Excel spreadsheet.