Sparkline by OKViz - Issue with tooltip date format

[Anonymous]

Hello,

I'm using the famous Sparline by Okviz because I need to show the lowest and highest data point in this line chart.

Everything is fine, the only issue is the tooltip showing this date format below:

I'd like to use a normal date. 

Has someone here used and faced this issue before?

Thank you.

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

You can change the format of the date so that it will display the normal format.

This is the data I created:

Here are the steps you can follow：

1. Create calculated column.

Column = FORMAT('Table'[date],"yyyy-mm-dd")

2. Put [column] and [amount] into Sparkline by OKViz.

3. Result:

Shows your date format

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.