Line charts with total line

[msin88]

Hi, 

I am trying to to make multiple graph where I want to compare numbers per Business Area with Group Numbers. When filtering I want to keep the group number (totals) and show the selected BA against Group.

When I try, I keep on getting all lines in my charts filtered as well and no lines for the total (Group).

Does anyone know how to solve this?

Thanks! 

[v-sihou-msft]

@msin88

No, you can't fix the total row/group in chart when applying a filter. I suggest you create a measure to show total value with ALL() filter and put this measure into a Card visual.

Regards,

[bullius]

Hi @msin88,

It sounds like creating measures for each line you want to show and putting these into the Values bucket of the line chart may solve your problem... 

[vanessafvg]

@msin88 can you give  a screen shot of the issue, i dont quite understand what your expectations are maybe if you can provide a visual of whats happening and how it should look