Power bi charts in desktop

[amanbhardawj]

Hi so I would like to create these dashed lines in my chart, any help or clues on this would really be

appreciated with an example. 🙂 

[Anonymous · Accepted solution]

Hi @amanbhardawj ,

I think you can try to create a "Line and clustered column chart".

Here is the result based on my sample.

Firstly we create a visual as below.

2020 Value line = 1

Change Percentage = DIVIDE(SUM('Table'[VALUE]),[Value for 2020])

Then select the Error bar in analysis pane.

Value for 2020 = CALCULATE(SUM('Table'[VALUE]),YEAR('Table'[Date]) = 2020)

Up = [Value for 2020]

Lower = SUM('Table'[VALUE])

Then turn on the data label for [Sum of Value] and [Change Percentage], you can transform the line type to dot and change the color as you want.

Finally we need to diy the data label for [Change Percentage].

Data Lable for Change Percentage = DIVIDE([Value for 2020] - SUM('Table'[VALUE]),[Value for 2020])

You can download my sample file to learn more details.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jai-Rathinavel]

Hi @amanbhardawj , I have created a sample view, you would need to use Line and Clustered column chart with dotted lines as format. Tweak your dax as per your business. Attaching the PBIX file below

Download PBIX

Did I answer your question? Mark my post as a solution

Thanks,

Jai

[MFelix]

Hi  @amanbhardawj ,

For this you need to do a combo line and bar chart and add also the errors bars.

Do you have a sample data that you can share?