Forum Discussion

jonashlock's avatar
jonashlock
Regular Visitor
9 years ago
Solved

Date Filter and grouping problems

I am trying to create a filter that has the following options to display the data:   Date range (day, week, month, year)  that would then have an option to group the data by the day, week, month or...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi jonashlock,

     

    #1. We are not able to set chart X-axis dipslay in different date range in one level. You can try to set differnet levels in different date range use drill down feature: Drill down in a visualization in Power BI.

     

    #2. Please check Edit Interactions in Power BI dekstop, check if the table visual is set to be filtered by the line chart.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi jonashlock,

 

Would you please share some sample data and screenshots about the desired results for our analysis?

 

Best Regards,
Qiuyun Yu

  • jonashlock's avatar
    jonashlock
    Regular Visitor
    9 years ago

    Here is a screen shot of my page

    Problems i am having with my data:

    1. Unable to build a filter that on the X axis will allow a user to change the date range and display it by the way they want (example:  Last 3 months data shown in Weekly view  or Last years data shown in monthly view)
    2. When choosing a date point on the report type the table below sorts on that data type (open, opened today or resolved) but shows the data for the full date range selected instead of a point in time.   Say I select Open on Jan 08 I would only want to see in the table the tickets that were open on Jan 08 and tagged as open today.  Instead I am currently seeing all data for Open (all dates, not just the 8th)

    I currently export 3 reports from our ticketing system with a report ran date time stamp.   Open, Opened today, and Resolved Today.   My line chart is built off of the report run date.  (to be able to show workload and backlog at a point in time)

     

    Did this help explaining the fun I am having? 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Have you considered using a slicer? I have had a similar problem to this in the past and was able to use a slicer in conjuction with a new column spilt off from the main date/time group. Just a thought.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi jonashlock,

       

      #1. We are not able to set chart X-axis dipslay in different date range in one level. You can try to set differnet levels in different date range use drill down feature: Drill down in a visualization in Power BI.

       

      #2. Please check Edit Interactions in Power BI dekstop, check if the table visual is set to be filtered by the line chart.

       

      Best Regards,
      Qiuyun Yu