cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gpiero Member
Member

Looking for advice to choice a suitable visual

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 

 

Stock.PNG

4 REPLIES 4
Community Support Team
Community Support Team

Re: Looking for advice to choice a suitable visual

@gpiero,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gpiero Member
Member

Re: Looking for advice to choice a suitable visual

@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

 

field.PNG

 

 

 

Dataset.PNG

JellevdWerff Frequent Visitor
Frequent Visitor

Re: Looking for advice to choice a suitable visual

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 Member
Member

Re: Looking for advice to choice a suitable visual

@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:

 

test1.PNG

 

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 60 members 1,136 guests
Please welcome our newest community members: