Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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.
Thanks to everybody, the solution was to add a simple measure as follows :
and the result was:
problem solved,
Thanks to everybody, the solution was to add a simple measure as follows :
and the result was:
problem solved,
Hello @amitchandak @lbendlin and @v-rzhou-msft ,
Thank you for your answers, the first part to transform the date column is ok but the problem is still that i can not display the data without adding sum.
I would like it to show me the option not to summarize for the data "note".
Hi @Anonymous
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.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , 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
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://www.youtube.com/watch?v=M5PvQUy-L_4
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.
Thank you,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |