Forum Discussion
Sort By Month and Year in Matrix + Line Chart
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
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.
2 Replies
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcHi 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.
