Forum Discussion
Data point value in Sparkline chart in a table
Hello All,
I have accomplished the requirement to show sparkline chart in a table for every row, Value by month. However I am not able to display the value of data point in sparkline chart when I do a mouse over on a specific data point. I referred to many videos and articles which showed Max(Tablename.fieldname) to show the data point value but this is not working for me. FYI, I have other fields in the table as well.
Thanks in advance,
Sowrabha
Hi Sowrabha_S
As a sparkline is no measure it can't give a concept for a tooltip page / drill through.
But you can create something like this :Or to put the minimum and maximum point in a column after the spark like :
The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
9 Replies
- Ritaf1983
Super User
Hi Sowrabha_S
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...I have a table with columns such as Key (with other few columns) and sparkline chart. The values displayed in chart are unique to the Key column. X axis in the chart is month and Y axis in the chart is Value. I am using Max(Table.Month) to display the selected data point in the tooltip but this is not working.
- govind_021
Hi ,
As of now , it is not possible to display data points in the sparklines in table or matrix.
try researching about svg codes or take help of any custom visual.I understand there is no way to display data points in the sparkline chart. I am looking for ways to display data point value in tooltip using report page option.
- Ritaf1983
Hi Sowrabha_S
As a sparkline is no measure it can't give a concept for a tooltip page / drill through.
But you can create something like this :Or to put the minimum and maximum point in a column after the spark like :
The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- anmolmalviya05
In Power BI, sparklines in a table are primarily designed for visual representation and don't inherently support displaying tooltips (like data point values) when you hover over a specific point on the sparkline.
Hi Sowrabha_S ,
Unfortunately, sparklines in Power BI tables don't inherently support displaying tooltips (like data point values) when you hover over a specific point on the sparkline12. This is because sparklines are designed to be simple, small charts that convey trends without detailed data labels.
You can post these suggestions (or vote for existing ones) at https://ideas.powerbi.com as those get regularly reviewed by the product team. You can vote for your idea and if there are more votes, the officials will take your Idea and launch the feature at the first opportunity.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
