Monitoring headcount

[Anonymous]

Hello, 

I am trying to present line graph with comparison of EBITDA per employee for 2 years, so I made a simple line graph with values for both years. But I need additional visual comparing headcount for those 2 years, and the values have to be in format for example January 500 / 505 (the first number is Headcount for first year, and second number is Headcount fo second year), something like in the picture. Is there any idea how could I do this in Power BI?

[Anonymous]

Hi Miguel, thanks for your answer, 

it doesn't have to be a singl chart, I made simple line graph for values in both years, but I am not sure how to make that visual 476/471 for months. Can I use matrix for that? It wouldn't have values for all months, it would go month by month.

[MFelix]

Hi @Anonymous ,

Yes you can use a matrix, if you place the months  / years in the columns and the measures on the values then you can adjust the colour of each metric to the values you need. something similar to this:

For the colour I used a condittional formatting measure:

Colour = IF(SELECTEDVALUE('Table (2)'[YEar]) =CALCULATE( MAX('Table (2)'[YEar]),ALL('Table (2)'[YEar])), "#E66C37", "#D9B300")

[MFelix · Accepted solution]

Hi @Anonymous ,

This cannot be done using a single chart the option is to create  a matrix table and had that condittional formating, however the only question is if the line chart has all the values for the months or if can change in number of months.