Forum Discussion

berkerustun's avatar
berkerustun
Frequent Visitor
2 years ago

Sparklines in matrix visual

Hello folks, i have an issue about adding sparklines on a matrix visual. I have a monthly based columns revenue matrix by customers at rows and when i add a sparkline by monthly basis too, i face with a single column added to every month with a dot. I do not want to see this new columns, i only want to see the same matrix and a total sparkline column, is there any way to do it. Best regards.

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Hello berkerustun,

     

    There are custom visuals available in the Power BI marketplace, such as Sparkline by OKViz, that you can explore. While these visuals are designed for standalone sparkline visuals, with some creativity, you might be able to align it with your matrix.

     

    You can also concatenate your monthly revenues into one column and then use a line chart visual to create the sparklines. This will produce a matrix-like table with the revenues displayed in a single column for each row (customer) followed by a sparkline (However, this makes the data less user-friendly in terms of reading individual monthly values).

     

    Should you require any further assistance, please do not hesitate to reach out to me.

  • berkerustun's avatar
    berkerustun
    Frequent Visitor
    2 years ago

    Thanks for your answer, but unfortunately this is not a solution for me. my matrix is like:
                 Month 1     | Month 2        | Sparklines by 12 Months
    Cst A |          x         |        y              | Sparkline A
    Cst B |          z         |         t              | Sparkline B
    i will solve it by talking my BI heads for another way to show them, appriciated, best regards.