Looking for advice to choice a suitable visual

[gpiero]

The visual below contains stock value data since summer 2016.

To make it more readable I would like to combine for each line

1. the value available at the end of FY 16 17 as single data
2. the line that represent the value for the current FY

I do not have any idea how to achieve that.

Is there some suggestion?

Regards 

[v-chuncz-msft]

@gpiero,

You may try dragging date from a calendar table and add an appropriate measure to Visual level filters.

[gpiero]

@v-chuncz-msft

Thanks for your feedback.

I think I did not catch the point. I have already in my dataset dates and join among tables.

What is not clear to me is how  to combine a single data (for example MAX or AVERAGE at end of FY for each of those value) in a line chart.

Regards

gpiero

[JellevdWerff]

Hi,

Maybe you can create a calculated measure or column in the stock table, with a calculation of the MAX(value) (highest price) or the value on date=MAX(date) (latest value). Then add these to your visual.

Regards,

Jelle

[gpiero]

@JellevdWerff, @v-chuncz-msft

The following measure works perfectly. I check the calculation and it is ok. No problem at this stage.

TotalStockAtDate = CALCULATE(AVERAGE(StockValues[TotalValue]);FILTER(StockValues;StockValues[Date] >= DATEVALUE("01/07/2016"));FILTER(StockValues;StockValues[Date] <= DATEVALUE("30/06/2017")))

What I am not able to do is adding this value in the chart in a proper way.

Pheraps I am wrong but I think that a Line chart does not allow to combine correctly as I would like to do.

Look what happens below if I add the measure above:

Line TotalStockAtDate overlapped to TotalValue till to the Date specified in the measure above.

I would like to represent TotalStockAtDate as a single point or circle or someting else at the left of the visual. Look at two red circles and imagine  them will represent MAX or AVERAGE or last value of each stock at the end of previous FY.

It could be a simple way to compare last FY vs current trend.

Is there some other visual better than that?

Many thansk for any help.

Regards

gpiero