Line chart extremely easy in Excel and hard in Power BI

[Anonymous]

Hi,

I need to create an extremelly easy line chart that is very easy to create in excel but somehow I do not know how to do it in Power BI. This might be because of my Data Set..., or other reason.

Can you have a look and help me out? This is the line chart I need to see:

The data set is also very simple. Please see attached: https://1drv.ms/u/s!AtEHWSVFE9URi1pQ7b0VwUw09eDx?e=coadGa

Can you help me to understand what is wrong I cannot generate such an view? I tried many times. 

Thanks!

Pawel

[parry2k]

@Anonymous see attached, I think that is what you are looking for.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi,

Thank you for enclosed file. Can I ask you why did you use Running Total? I do not think it works for me. 

As you can see in the screen attached, an X ax shows Score sorted from 1 to the last score value = 478. 

I am not sure if your calculation will work here. Somehow I cannot do it in Power BI. 

Hope you can help me,

Thanks,

Pawel

[Anonymous · Accepted solution]

It works when I add a index as a sequence number.