Want measures from category on the graph, not the measures from Totals

[Anonymous]

Hi experts,

Following is my requirement in snapshot: There are two slicers Location & employees:

'Fortnight Payment' is a common measure for both the locations calculated based on employees selected.

'A Billings' & 'B Billings' are two measures calculated from different tables. I designed the report with Matrix visual.

'Difference' column is populated by two measures- [ A difference] & [B difference]. In grand Totals, [Loc A difference] & [Loc B difference] columns automatically calculate the difference by subtracting 'Total Fortnightly payment' from 'A Billings' and 'B Billings'(highlighted in yellow in snapshot below)

Now I want this data on 'Line & Stacked column chart' graph. I specified line values as 'A Difference' & 'B difference'. Automatically, on the graph the line values pick up the Difference columns from totals(highlighted in yellow in snapshot below).  In Line values I want "Difference" columns of location A & B (marked in red in snapshot below), not the  Difference columns from totals (highlighted in yellow in snapshot below). 'Total Billings' & 'Difference' (marked in blue) under totals are measures I created.

Please suggest/help.

Many thanks in advance,

Meena

[Anonymous]

For some reason, I can't edit my orignal message. Here is the graph I get:

As you see, the values on x-axis are from 'ADifference' & 'BDifference' columns from totals (highlighted in yellow in matrix snapshot).  I want 'ADifference' & 'BDifference' values of location A & B (marked in red in matrix snapshot).

[amitchandak]

Not sure I got it completely. But have tried dragging location (Which has value a,b) on the legend

[Anonymous]

@amitchandak  thanks for your suggestion. Yes, including location on legend gives me correct values. But On line graph if I include 'Location' on Legend, i can't have two measures 'A difference' & 'B difference' in line values. It allows only one measure. 

Tried 'Line & stacked column' chart. It works with the two measures in line values but the graph doesn't make much sense & shows incrrect values for the location not in focus. 

For example: for 10/9/2019 the expected A Difference & B difference are following

But on the graph A difference is incorrect, it should be 28448.66. However, Location B difference is correct 

Location A DifferenceLocation B Difference

[amitchandak]

Can you a measure which do not filter on A and B and try

Like fortnightly payment and billing and their diff. 

[Anonymous]

@amitchandak  Yes 'Total' measures - Total Fortnight payment, Total Billings & Difference which are not filtered by location, show correct values on the graph..

[amitchandak]

But do not show correct value when you use location as a legend?

[Anonymous]

@amitchandak   it does show correct values for any of the total measures (which I can use only one measure in Line value) when location is used as legend.

[Anonymous]

@v-juanli-msft, @v-shex-msft ,  @Greg_Deckler  and @v-qiuyu-msft  you had provided a solution to similar issue in a post, I can't get that solution to work for me. Your help is much appreciated. Apology for tagging you in case it causes any inconvenience to you.