How to reference data calculated within a Line Chart

[Anonymous]

Hi guys,

I have a line chart (pic below) where the data is chosen to be the median (in the drop down option in the Y-axis), and I need to be able to reference the values for Market and Client separately. The client data I believe is just one row, so is not really a median value, but the Market data will have many rows to calculate the medians.

My issue is that I would need to find the median for every year individually if I used a measure to calculate the median values for the Market - which is inefficient and new data gets added regularly. This median is different than if I just apply a =MEDIAN() to the data. But I can see the values when I go on table view, and I know I can export this tabulated data into a CSV, but again I would like to avoid this and keep it all calculated within the report.

So, I would like to reference the data table from the graph that it shows (such as table below), so that I can use this in other calculations/visuals.

Renewal Year	Branch	Median of FOT Rate
2016	Market	3.30%
2016	Client	2.55%
2017	Market	3.58%
2017	Client	2.51%
2018	Market	6.00%
2018	Client	4.10%
2019	Market	5.94%
2019	Client	4.14%
2020	Market	7.47%
2020	Client	4.70%
2021	Market	7.63%
2021	Client	4.80%
2022	Market	8.20%
2022	Client	4.58%
2023	Market	9.16%
2023	Client	5.70%

Thanks!

[amitchandak]

@Anonymous , Based on what I got

a New column =

MEDIANX(filter(Table, [Renewal Year] = earlier([Renewal Year]) ), [Median of FOT Rate])

a new measure =

MEDIANX(filter(allselected(Table), [Renewal Year] = max([Renewal Year]) ), [Median of FOT Rate])

[Anonymous]

@amitchandak thank you for your reply. I only have [FOT Rate] and the 'Median of FOT Rate' only comes within the table data drop down options, as I have shown in picture below. How would this affect your code you have written above?

Thanks