Forum Discussion

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago

Error in Date slider slicer

Hello Experts,   I am creating my first Dashboard and hope you can guide me through, 🙂 My Dashboard in PowerBi desktop is connected to a SharePoint list. The SP list has a Date/Time column named ...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Sample data. We cannot give you a solution if we don't know the column names, etc.

 

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago

Hi Greg_Deckler,

Please find the information including more details. Let me know if any further information is required. 🙂

I have two different SP list in the PowerBi desktop. In order to merge the information, I select the option "Merge Queries as New". This new query is the one I am using on my dashboard. After I merge the information, I modified the column "STA Assignment Data.Modified" to be Date. --> this is the real name of the column

 

 

 

 

 

 

 

 

 

 

 

 

 

After adding the Timeline option in the dashboard, I added the column "STA Assignment Data.Modified" under the field "Time", as highlighted in the below image. I also noticed after I changed the column to "Date", the column display more options (Year, Quarter, Month, Day). 

I am wondering if I am missing one step since my Timeline is not showing any data

9the dates) that is recorded in the column "STA Assignment Data.Modified".