Forum Discussion

FabScone75's avatar
FabScone75
Icon for Helper I rankHelper I
6 months ago
Solved

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 (Ye...
Need Help
  • RicardoTraNa's avatar
    RicardoTraNa
    6 months ago

    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!

RicardoTraNa's avatar
RicardoTraNa
Icon for Responsive Resident rankResponsive Resident
6 months ago

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!