Sort By Month and Year in Matrix + Line Chart

[mpribadi07]

Hi everyone,

Appreciate if you can offer some help for my problem below. I am relatively new to Power BI and can definitely use some of your wisdoms. 

I would like to re-create the pivot table as below in Power BI and can't figure out how to make the column sort by Year + Month and also how to make the Line chart per row as shown below:

Really appreciate any help that you can give me on this problem. Thank you!! 

-Marsha 

[v-jingzhang · Accepted solution]

Hi @mpribadi07 

Not sure what your data looks like. For the first question, you can add a month number column to your table and sort month name column by month number column. Put year and month name columns into a matrix visual and click expand icon on upper right of the visual to expand the columns. Reference for matrix visual.

For the second question, here are two blogs about sparklines that may be helpful.

SVG Sparklines - Line - Microsoft Power BI Community

Adding Sparklines to the Table and Matrix Visual (... - Microsoft Power BI Community

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[amitchandak]

@mpribadi07 , There are two parts. One you need SVG spark line

https://www.youtube.com/watch?v=xLD8HKwPWHE

Second, you need hybrid display

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc