Visualizing multiple measures in one chart

[Lancelot]

Hi

I have a number of measure which I would like to visualise in a single chart as below.

Ideally I would like Total cost of sales and revenue displayed side by side and cost of sales over revenue as a line indicating the movement over the four years period.

Any assistance will be greatly appreciated.

[v-jingzhang]

Hi @Lancelot 

You can try the Matrix visual in Power BI. After adding multiple measures to a matrix, turn on the option "Switch values to rows" in format pane. 

Create a matrix visual in Power BI - Power BI

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Idrissshatila]

Hello @Lancelot ,

What you could do is add all these measure in a field parameter and add the value of the parameter in the table.
check this article for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin