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.

     

  • itskool's avatar
    itskool
    Advocate II
    4 years ago

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