How to show an specific value in a line chart?

[Julio-YYC]

Hello everyone,

I have a line chart, and when I click on a specific date, my card will show the value for that day, like this: 

Clicking on Oct-02, Card shows 5 (that's okay!)

However, when all the dates are select in the chart, the card shows the total count (20):

But what I want to see in the card is only the last value (6) instead of 20 when I am selecting all the dates.

Does anybody know how to get it solved in Power BI? 

Many thanks

Julio

[v-yangliu-msft · Accepted solution]

Hi  @Julio-YYC ,

sorry, i understood wrong.

Here are the steps you can follow：

1. Create measure.

Measure =
var _select=SELECTCOLUMNS('Table',"1",[Day])
var _maxdate=MAXX(ALL('Table'),[Day])
return
IF(
_maxdate in _select,
SUMX(FILTER(ALL('Table'),'Table'[Day]=_maxdate),[Value]),
SUMX(FILTER(ALL('Table'),'Table'[Day] in _select),[Value]))

2. Result:

Best Regards,

Liu Yang

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

[Julio-YYC]

I Appreciate that Liu Yang, it's working perfectly.. many thanks!

[v-yangliu-msft]

Hi  @Julio-YYC ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _elect=SELECTCOLUMNS('Table',"1",[Day])
return
SUMX(FILTER(ALL('Table'),'Table'[Day] in _elect),[Value])

2. Result:

Select Single：

Select all：

If you need pbix, please click here.

Best Regards,

Liu Yang

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

[Julio-YYC]

Hi Liu, 

Actually, when selecting all the chart, I need to show "6" on the card (the latest date available on Oct-05) instead of 20.

[mangaus1111]

Hi @Julio-YYC ,

try this

Measure = CALCULATE(

                   MIN('Facts26'[Value]),

                   'Facts26'[Day] = MAX('Facts26'[Day])

)

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

[Julio-YYC]

Hi Mangaus, 

The solution from Liu worked better for me...anyways, thanks for helping!