Forum Discussion
Cannot understand sparkline values
Hi all,
I have a matrix, which is reporting on data sources for reports in a tenant.
We have Data Source, Workspace Name and Report Name in a hierarchy on the rows, and the date on columns (YearMonth). The value being reported is count of reports (Report count) by creation date.
I am not using calculation groups. I added the sparkline to the report count measure, showing YearMonth on the x-axis. The result is shown below. The sparkline doesn't correspond to the numbers. And I'm at a loss to explain what it's showing here.
Can anyone shed some light on what the sparkline is showing? I am about to simply remove it because it's not making sense to me.
Hi! This is expected behavior. Matrix sparklines in Power BI are calculated independently of the visible matrix columns. The sparkline evaluates the measure across the full YearMonth axis for the current row context, which is why it may not match the numbers shown in the matrix columns.
You can validate this by placing the same measure in a simple table by YearMonth. If exact visual alignment is required, you may need to adjust the date filtering or consider removing the sparkline.
Best Regards!
4 Replies
hello FabScone75
try checking this page.
Create Sparklines in a Table or Matrix in a Power BI Report - Power BI | Microsoft Learn
your issue might be come from choosing the field when creating sparkline
usually i put the same y-axis and x-axis as line chart then it will show exact same pattern with line chart. This way we can show line chart without making line chart.
Hope this will help.
Thank you.
Hi! This is expected behavior. Matrix sparklines in Power BI are calculated independently of the visible matrix columns. The sparkline evaluates the measure across the full YearMonth axis for the current row context, which is why it may not match the numbers shown in the matrix columns.
You can validate this by placing the same measure in a simple table by YearMonth. If exact visual alignment is required, you may need to adjust the date filtering or consider removing the sparkline.
Best Regards!Hi FabScone75
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.Hi FabScone75
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
