je voudrais afficher ce tableau sous forme de matrice sur power bi desktop
sauf que power bi me propose sur la matrice le nombre de notes et pas le note même finalement je voudrais avoir un aperçu comme ça :
merci d'avance pour votre aide,
Solved! Go to Solution.
In addition to amitchandak 's reply, it is better to build a sort column in whole number type. If you use format function to build a year month sort column, it is in text type.
Try this calculated column:
Month Year sort = YEAR(Sheet26[Date])*100+MONTH(Sheet26[Date])
Your Month Year column may in formatting "mmm-yy" instead of "mmm-yyy".
Month-Year = FORMAT([Date],"mmm-yy")
My Sample Table is as below.
Sort Month-Year by Sort column like amitchandak 's link.
Result is as below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@oguedda , On the date you have to create month year.
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm") // sort month year on month year sort link of doc
You have to take the month year on the column on the matrix.
Refer for matrix visual :https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
I found the solution on this page https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/ there are lots of tips in it that can help many people.
Do you have a calendar table in your data model that has a month name and a month number column (the latter for sorting)?
Change the matrix visual to switch off the stepped layout for the rows.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.