Forum Discussion
How to reference data calculated within a Line Chart
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 sep...
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])
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