highlight and label the last data point

[VicGeg]

To illustrate the trend, I plot daily values in a column chart, by date. To avoid clutter, I don't display value labels nor axis. But I do want to show the value label for the latest data point, ideally, highlighting that column. Surprized that this is not a standard feature. Is there a solution?

[v-ljerr-msft]

Hi @VicGeg,

It is not possible to do it currently as Matt mentioned above. Could you submit your requirement on Power BI Ideas and vote it up to improve Power BI and make it better?

Regards

[GilbertQ]

@VicGeg you could potentially download and use this custom visual which might be able to show what you are looking for.

http://okviz.com/sparkline/ 

I do know that it does hvae the ability to highlight, as well as display the last value.

[MattAllington · Accepted solution]

Yes, it is not currently possible. Power BI is not yet 18 months old and there is still a lot to do. I suggest you investigate the tool tips feature. You can put any measure onto tool tips (multiple actually). You can also write a measure that returns a text value using VALUES(). something like this

=if(hasonevalue(table[column]),values(table[column]))

add this or any other measure to the tool tips, and when you hover the mouse you will see the information displayed. It's a pretty good experience. 

[cabc_xlorla]

Hi Matt,

greetings from Lima, Perú.

Do you know if still not possible? thanks!

[VicGeg]

I am showing the value by date in a column chart to illustrate the trend (to declutter, I hide value labels and axis), but I need to display the value of the latest (let's say, yesterday's) entry. Ideally, I'd like the visualization to automatically hi-light the last column and show the value label on it.

Possible?

Thanks in advance

[MattAllington]

This looks like a duplicate post. I replied in the other post.