Problem with line chart

[Anonymous]

Hi All,

We have used a simple line chart in the report, wherein X-axis use Date, in Y-axis use Sales and in legends use Store as shown below. The problem here is that when I am select a few stores in slicers It shows total Quantity in the card, but when we try to select only one line from these three lines, it not reflect the total Quantity of that selected line, but it only reflects the quantity of that date selected.

Expected Result:

When we select only one line from these three lines in a card it shows Total Quantity of that selected line and not that selected date.

Thanks in Advance.

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

It because when select a line in line chart, it select sigle date as well, We can try to use following measure to meet your requirment:

Measure = IF(DISTINCTCOUNT('Table'[Store])=1,CALCULATE(SUM('Table'[Quantity]),ALL('Table'[Date])),CALCULATE(SUM('Table'[Quantity])))

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？

By the way, PBIX file as attached.

Best regards,

[Anonymous]

Sorry Please read In Y-Axis use Quantity