Forum Discussion

Fronde's avatar
Fronde
New Member
3 years ago

Utilisation vs Target in Matrix and Stacked bar/column chart

Hi there,

 

I am very new to Power BI and would like to get some help on my utilisation report.

I have the first column as the target hours for everybody and then their hours worked under each category.

I would like to have an extra column for variance between Target and Total. And also to transform this information to a Stacked bar/column chart with % information, anyone with an exact match of target and total will be 100% and then + variance might be 104% (for 176 vs 168), and -variance is 83% (for people have 140 vs 168).

Hope it makes sense to you.

Thanks in advance!

 

Need Help

1 Reply

  • Shaurya's avatar
    Shaurya
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi Fronde,

     

    First of, you can calculate the % for bar chart by creating the column:

     

    % = 'Table'[Total]/'Table'[Target]

     

    Format the above as a % to see number like 100%, 85%.

     

    You can create positive and negative variance by using:

     

    +ve Variance = IF('Table'[%]>100,'Table'[%],NULL)

     

    -ve Variance = IF('Table'[%],100,'Table'[%]*-1,NULL)

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: Forecast Period - Previous Forecasts