Power BI - Line Chart under Matrix

[PBI_V2]

Hello All,

We have requirement to create a below chart in Power BI in which we have a matrix consists of Segment(s) e.g. Hardware, Software, Network, Service, Cloud & AI & Purchasing Dates. Under this matrix, We have line trends with respect to each date & respective segment. 

Is it possible to create such chart in Power BI. If yes, how to create it. If not. suggest any alternatives.

Thanks,

PBI V2

[v-xinruzhu-msft]

Hi @PBI_V2 

In the matrix, it cannot implement the visual like this, but you can consider to use the custom visual to implement the similar visual.

Download the custom visual 'multiple sparklines'

Then put the following field to the visual.

Output

Best Regards!

Yolo Zhu

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

[PBI_V2]

Hello @v-xinruzhu-msft ,

Thanks for your respose. It will fulfill our requirement. Following are the question(s) on this visual.
1) Is this visual is free or need to buy some license

2) How to know whether it is approved visual by our organization.

3) Is it possible to create the required chart by using R or python visual

Thanks,

PBI V2

[v-xinruzhu-msft · Accepted solution]

Hi @PBI_V2 

Thanks for your quick reply.

Based on your consideration, you can try the folloing solution.

Create a line chart, then put the date to x-axis, and put the value to the y-axis, then put the product to small multiples.

Then in properities, set the column of small miltiples to 1.

Output

Best Regards!

Yolo Zhu

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