Search code examples
excelpowerbisparklines

How to use Power BI Sparkline like Excel


Is it possible to create a sparkline in power bi desktop without using date. for example I have 3 columns which have their own values. I want to show these values in a column which is a sparkline exactly like spark line in excel. I need something like this in power bi: see this picture

How can I create it? What should be in x-axis and y-axis? Thanks


Solution

  • Power Bi doesn't work on pivoted (wide) tables like Excel does, but on stacked (long) tables instead. So you have to prepare your data accordingly. You can still show it in wide format afterwards using a Matrix visual. However, to add sparklines like in your example you would need a table that is just filtering by rows. Here you can add spaklines with Value on the Y-axis and Column on the X-axis. The aggregation doesn't matter for your sample data, so leave it to Sum.

    enter image description here