Latest Enterprise DNA Initiatives

YTD & FYTD Graph

Hi, i have created some analysis slicers “Month”, “YTD”, “FYTD” and “PTD” which i am using in conjunction with the month and year slicers from my date table to showcase actuals against budget etc for the specified analysis period, this all works well no problems here.

But i want to showcase some of the values in a bar chart so for example when i choose “YTD” i want the bar chart to show the values up to the selected month. So if i have “May-20” selected i want the graph to show the values by month up to May-20 but becuase i have a date slicer on my page when i load in my months from my date table the graph as you would expect filters down my graph just to the month selected. I tried turning off interactions between my month slicer and my graph (see pic below) but then all the months show which isn’t correct either, now that i am wrtiting this out i’m thinking i need a seperate date table is that right? Any help would be much appreciated, thanks.

Hi @BCS,

Yes a disconected date table used to harvest date selections is the way to deal with this type of scenario. You’ll find many examples of that on the forum, just use the Search option in the upper right of your screen, to get you started here are two examples.

And this recent video by Brian.

I hope this is helpful

1 Like

Thanks you Melissa