Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 headcou...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    MFelix
    Super User
    4 years ago

    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")