Forum Discussion

Mattbidev101's avatar
Mattbidev101
Icon for Helper I rankHelper I
5 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
5 years ago

Hi,

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

Mattbidev101's avatar
Mattbidev101
Icon for Helper I rankHelper I
5 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
    5 years ago

    Hi,

    You may download the PBI file from here.

    Hope this helps.

    • Mattbidev101's avatar
      Mattbidev101
      Icon for Helper I rankHelper I
      5 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?

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

        Hi,

        You are welcome.  You may modify my cumulative revenue measure with an IF statement.  If the revenue is 0, then blank else my cumultive revenue measure.  If you are unable to do it, post back.