Stacked bar difference to be shown as line graph

[stvesanity]

Hi, 

Need your expertise, please.

I'm trying to show the difference between two bars in my clustered bar chart -- the result will be added as line chart or any recommendation as to how to show it is welcome. 

is it possible?

orange - total hours

blue - forecasted hours

[v-alq-msft · Accepted solution]

Hi, @stvesanity 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Diff = SUM('Table'[Total Hours])-SUM('Table'[Forecasted Hours])

Then you may display the result with 'Line and clustered column chart'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stvesanity]

@PaulDBrown  hey Paul, would it be okay to seek for your assistance about this as well? Appreciate your help

[amitchandak]

@stvesanity ,

Diff =[forecast] -[total hour]

USe clustered line visual

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

[stvesanity]

apologies if i was unclear 

the forecasted hours (188 = total for the month and it's 37.5 = week)

prob is, 

1. i'm always subtracting it to 188

2. i have 1 filtered item in forecasted hours (not included as forecasted hours in my raw) 

3. related to 2nd item, if i'm directly running what you have provided (forecast hr)-(actual hr) my concern in 2nd item is also included

sorry for being pain

[PaulDBrown]

@stvesanity 

@stvesanity 

If you include a filter in the filter pane, the corresponding table will be filtered accordingly for all the measures you include in the visual. So if you exclude a value, the measures will compute the result excluding the value you have filtered.

Having said that, as @amitchandak  suggests, the best way to undertsand the potential problem is to see an actual example, as in a sample PBIX file or a sample dataset (without sensitive data of course) with the measures and expected output. (You can upload and share these in a cloud service such as Onedrive, Google Drive, Dropbox...)

It´s hard to understand what the issue is from the images you have posted.

[amitchandak]

@stvesanity ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[stvesanity]

@amitchandak 

here it goes -- appreciate your help

2nd screenshot is the 

value = hours spent/task

column = expected hours/wk  and expected hours/month