Forum Discussion

Paulien1989's avatar
Paulien1989
Icon for Advocate II rankAdvocate II
8 years ago

Graph with date shows months not selected through filter

Hi everyone,   I'm currently struggling with visualizing data in a line graph where at some points, there is no data.   Speficially: I want to show the number of emails sent over time. On the y a...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

How are you doing the filtering to the last 12 months?

 

  • Paulien1989's avatar
    Paulien1989
    Icon for Advocate II rankAdvocate II
    8 years ago

    I tried several filters:

     

    - Visual relative filter Last 12 Months (calendar)

    - Page relative filter Lat 12 Months (calendar)

    - Date slicer selecting 1st may 2017 thru 30th april 2018

    - Page / visual filter stating Date is on or after 1st may 2017 AND before 1st may 2018

     

    All give this same result...

     

    I now have a workaround where I used a Year-Month text field on the axis and I manually selected the months I want to show, sorting them by a year-month numeric index dragged into Tooltips. It's not dynamic though.... cannot use dynamic date filters this way.

     

    Hoping for a correct and dynamic solution.

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Paulien1989,

       

      Is there an existing relationship between calendar table and fact table based on date column? If so, you just need to add [date] from calendar to slicer, also add it to X-axis of chart. When you select to show Last 12 months from relative slicer, the chart will be fitered dynamically.

       

      Regards,

      Yuliana Gu