Forum Discussion

Mattbidev101's avatar
Mattbidev101
Icon for Helper I rankHelper I
6 years ago

Filter on Cumulative YOY graph not working

I have this report that you see here with an issue on my cumulative graph.  When you hover over the bar in the cumulative revenue graph, you'll see that the cumulative revenue tooltip doesn't match t...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Share the link from where i can download your PBI file.

  • Mattbidev101's avatar
    Mattbidev101
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for replying.  I think I was able to share the pbx file...

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      You may download the PBI file from here.

      Hope this helps.

      • Mattbidev101's avatar
        Mattbidev101
        Icon for Helper I rankHelper I
        6 years ago

        Thanks for taking a look at this.  One thing i noticed was that on the file you shared, the current month's data is replicated across future months for the current Fiscal year (20-21).  I couldn't figure out how to cut that off  October on your code like you see in my original.  Also, I've tried using DATESYTD function before to build this graph and didn't get the same result.  What was the key here?  was it just having that Dates table that you built?