Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The visual below contains stock value data since summer 2016.
To make it more readable I would like to combine for each line
I do not have any idea how to achieve that.
Is there some suggestion?
Regards
You may try dragging date from a calendar table and add an appropriate measure to Visual level filters.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
106 | |
78 | |
73 | |
52 |
User | Count |
---|---|
145 | |
107 | |
107 | |
90 | |
64 |