Only keep total for sparkline

[itskool]

Hi all,

I'm trying to add a sparkline to my matrix which shows the dynamics from month to month.

The problem is the columns in my matrix are also months which makes Power BI add a sigle dot to them.

Any idea if there is a possibility to only keep the sparkline for the total (remove these two "Gap" columns in red rectangles)?

Thanks!

[Anonymous]

Rename the Sparkline Column to a space.
The columns with dots disappear (shrink), then go to the total column of the sparkline and increase it so that the graph appears only in that column. When formatting in Column Header, you can set the resizing width Off

[v-henryk-mstf · Accepted solution]

Hi @itskool ,

Just narrow the width.

Best Regards,
Henry

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

[dakotajang]

Interesting workaround.

But it would be nice to have something to handle this more nicely.

For example, I want to achieve the following (examples using financials sample dataset).

It is a different workaround where I overlay the matrix without sparkline on top of the matrix with sparkline.

Best I can do with one table at the moment is the following.

I do not want to display the Total column.

I also wanted to hide the label for the values and it ended up cutting off the "Product" in the header.

I hope to see the feature in the "Format visual" tab to customize this sparkline visual.

[itskool]

ok, that should be fine for a workaround, thank you!

[v-henryk-mstf]

Hi @itskool ,

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[itskool]

Hi Henry,

Thanks for the reply.

It is not really clear to me from the screenshot - how did you make the lines disappear?

[amitchandak]

@itskool , even if you use all or time intelligence you will only get one consolidated value. I doubt this