Max year Sales

[Ankit777]

Hi All

I have yearly sales data. In a KPI chart I want to show max year sale when nothing is selected in year filter. Once the year is selected, I want to show that year sales in the chart. How can I do that?

Please help!

Thanks 

Ankit

[DoubleJ]

Hi

Not quite sure whether I understand your question correctly.

Given a table with columns "Year" and "Sales". In the KPI visual you can simply use the Sales as Indicator and Trend axis. You can additionaly switch the trend axis off to hide it (as it does not have a meaningful value in this case).

KPI visual set upHide trend axis

No year selectedOne year selected

Is this what you are trying to achieve?

Hope this helpls!

JJ