Sparkline on a matrix with monthly columns

[YO_CO]

Hi all,

I'm trying to set up something which is trivial in Excel, but seems almost impossible in native PBI unless you know SVG coding.

I have a simple matrix with categories and one measure divided into columns based on DimCalendar[Month Name].
It would look something like this, with the matrix parameters on the right:

I want to do a simple thing - add sparklines as a final column:

Why is this so impossible in PBI?
Whenever I try to add it, it adds a sparkline column for each month.
This happens in calculation groups as well.
I know I can try and minimize the monthly sparkline columns, but this is not a dynamic or professional solution.
I also found a possible complex workaround (though not dynamic with years), if you know SVG coding - but this is not always viable.

Tried separating the sparkline into a new table with single column, but it just looks bad, the interaction is not great and in a matrix with +/- options this is not syncronized.

There is another partial solution using field parameters which is not as dynamic as I had hoped.

What am I missing?

Thank you

[YO_CO]

Thanks @lbendlin , can't believe this is the best we have but still...

@Anonymous Thanks, but this only works partially on static tables with no formatting. For real reports, going to management, which has formatting, borders or any kind of change from the most basic layout - this just isn't good enough.

[Anonymous]

Hi, @YO_CO 

Although the sparkline adds a sparkline to each column, it can be hidden by manually adjusting the column name and width.

Best Regards,

Community Support Team _Charlotte

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

[lbendlin]

Yeah, you kinda have to use separate visuals if you want both the sparkline and the date hierarchy,