Displaying Data Labels for the latest Month

Question

Hi All,

I have a Pivot table where horizontal axis is Month ,vertical axis is Brand and revenue as measure and have a line graph created based on the pivot table. what I did is Opened Chart Properties -> Title and Labels - > Data Markers -> Display Options -> Show Data Labels ->Show Always. So what happening is its displaying the revenue values at different monthly points.

What my requirement is to display only latest month revenue figures  and suppress all other revenue data markers??. Thanks in advance

Thanks

Raj

asim cholas · Answer

Create two seperate analysis one for pivot and another for chart and keep it in same dashboard page

Gianni Ceresa · Answer

Yes,  so his first answer (not possible) still apply.

He was asking because maybe you wanted in the chart only the last month and not the previous ones.

But you want the 6 months and showing the value of last month numbers next to where your lines end (and that the not available option)....

user13483708 · Answer

Hi Krishna,

Basically there is pivot table data with say last six months data and I am converting the pivot table data view to chart view so having last six months data displayed on line chart. of which customer wants to display the data labels only for last month.

Thanks

Raj