Dynamic Target line in Waterfall

[Rohit_Negi]

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:-

[Claudio_Prado]

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.

[Vish24]

Are you able to solve this. Please share the solution. I also want to make similar visual

[v-danhe-msft]

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

[Rohit_Negi]

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.

 

[v-danhe-msft]

Hi @Rohit_Negi,

Based on my test, I am afraid you could not achieve this feature currently, you could vote for this idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20015260-dynamic-constant-line-fo...

Regards,

Daniel He 

[Rohit_Negi]

Thank you Daniel,

I have voted for the same. Hoping and Looking forward for this feature to be incorporated in new updates for Power BI :).

[v-danhe-msft · Accepted solution]

Hi @Rohit_Negi,

It's pleasant that your problem has been solved, could you please mark my reply as Answered?

Regards,

Daniel He