Forum Discussion
Monitoring headcount
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?
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.
3 Replies
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.
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")