Forum Discussion
Dynamic Target line in Waterfall
Hi,
could you please help me out as i am unable to insert dynamic Target line in waterfall chart.
Please find below the data and waterfall for reference purpose:-
Hi Rohit_Negi,
It's pleasant that your problem has been solved, could you please mark my reply as Answered?
Regards,
Daniel He
7 Replies
Hi Rohit_Negi,
Based on my test, you could refer to below steps:
Sample data:
Create the Waterfall visual:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Daniel,
Thank you for quick response.
As per the steps mentioned we will be able to show waterfall data for all months in one visualization.
What i want is we select month on filters and the waterfall data changes as per the filters, but i am not able to draw dynamic target line. However i am able to draw target line through analytics option. Please assist for dynamic target line.
Please find below the constant target line which is 126 for the month of February. however when i select January in Filter it still remains same as it is constant line. Please assist.
Hi Rohit_Negi,
Based on my test, I am afraid you could not achieve this feature currently, you could vote for this idea:
Regards,
Daniel He
Are you able to solve this. Please share the solution. I also want to make similar visual
You can create a line bar and add it on top of your waterfall with no background titles etc. I have the pbix done but do not know how to upload it.
