Forum Discussion

itskool's avatar
itskool
Advocate II
4 years ago
Solved

Only keep total for sparkline

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...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

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's avatar
dakotajang
Microsoft Employee
3 years ago

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.