cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
liapot Frequent Visitor
Frequent Visitor

Generate a report based on the date in the date slicer

Hi! I am new to PowerBI. I hope you can help me on my inquiry.

 

I need to generate a report that will show all active users depending on the date selected. Active users are users that have logged in the system atleast within 48 hours. 

 

I have created a date slicer using the column date [Date First Logged In]. Problem is i need to show the dates for the last 3 months. What is only shown are the 3 dates recorded in DateFirstLoggedIn. Does this mean i have to create a new column just to show all the dates for the last 3 months?

 

I am pasting what I have done so far. Appreciate any help. Thanks!

 

3 REPLIES 3
liapot Frequent Visitor
Frequent Visitor

Re: Generate a report based on the date in the date slicer

Screen Shot 2018-10-31 at 4.51.19 AM.pngReposting a screenshot

 

 

Re: Generate a report based on the date in the date slicer

Yes, you have to create a date column, which contains all the possible dates and ideally, even everything in between.

 

Also, this column needs to be of the 'date' datatype.

Community Support Team
Community Support Team

Re: Generate a report based on the date in the date slicer

hi, @liapot

You may use a relative date slicer and filter in Power BI Desktop

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

but why in your screenshot Date first Logged in on has four values? could you share some data sample and the expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 114 members 1,469 guests
Please welcome our newest community members: