For the matrix graph, how to add an extra column that includes a sparklines for all years

[MGadAllah]

Hi,

@Harsh

Please @Harsh … for the matrix graph, when I added the sparklines to the matrix, I found it created an extra column for each, which is not the thing I am looking for.
Is it possible to create one single column that contains a cell that includes sparklines for all years as we do it in excel?

Thanks a lot for your valuable time helping me.

[Harsh]

Hello @MGadAllah,

Thank You for posting your query onto the Forum.

Power BI doesn’t works like Excel. Because in Excel that fields/visuals are added and placed manually, as per our requirements wherever we deem fit. By default, that’s not possible in Power BI and therefore, it’ll add a sparkline for each column. But you can adopt an alternative by hiding all the individual/unrequired sparklines for those columns and only retaining it at a grand total level. Here’s how you can do that -

Go to the “Format” menu >>> under that go to the “Column Headers” and disable the “Text Wrap” option. Below is the screenshot provided for the reference -

Now, perform the task as showcased in the below provided GIF -

Finally, after hiding all the un-required columns, your report will look like this -

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Spark Lines - Harsh.pbix (3.5 MB)

[MGadAllah]

Hi,
Is it possible @Harsh to hide the Total Sales by Order Date column, and only keep the sparklines column?
I mean for the above visual, to have the WesternAustralia followed by the sparklines directly.
Thanks