Graph with 2 Lines Using One Table

[tksnota]

Hi

I want to create a chart showing 2 lines namely debit and credit using the cost (bdr_hfl).

I don't want to split the table between credit and debit.

Kindly advise if it is possible.

Thanks...tksnota...

[FreemanZ · Accepted solution]

hi @tksnota ,

yes, pivot the category column in power query, then everything will be more intuitive.

about pivot, check this:

https://learn.microsoft.com/en-us/power-query/pivot-columns

[Anonymous · Accepted solution]

Hi @tksnota ,

Did FreemanZ's reply help you?

In my opinion, I think you want us to recommend a visual. Line chat in Power BI is possible.

Put date as x-axis, bdr_hfl as y-axis, category as Legend. Then you will get the same content as in the image you provided.

Best Regards,

Stephen Tao

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

[FreemanZ · Accepted solution]

hi @tksnota ,

yes, pivot the category column in power query, then everything will be more intuitive.

about pivot, check this:

https://learn.microsoft.com/en-us/power-query/pivot-columns