HI friends … i want to get midyear summary also in waterfall chart.
Actually i have a data in which data is starting from January and ending in dec. Normally waterfall chart will give me cumulative total at starting and end with details in between. I also want to see cumulative total in June as well for mid year audit. Please guide how it is possible…i will be highly thankfull.
regards
I guess the simplest way to achieve this would be:
Have a date table with Half Years marked up H1 and H2. I’d recommend the EDNA date table which contains many ways to slice a calendar.
Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum
Set your report page up with 2 waterfall charts, using the filter pane to filter each with H1 and H2 respectively
Cheers
Pete
Hello @praveer82, good to see that you are having progress with your inquiry. Did the response from @BINavPete help you solve your inquiry?
If it does, kindly mark it as solution.
If not, how far did you get and what kind of help you need further?
Hi @praveer82, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.