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. 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.

Anonymous's avatar
Anonymous
Not applicable
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