présentation des données sous forme de matrice sans appliquer de calcule sur les données

[Anonymous]

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,

[Anonymous · Accepted solution]

Thanks to everybody, the solution was to add a simple measure as follows :

and the result was:

problem solved,

[Anonymous]

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".

[v-rzhou-msft]

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. 

[amitchandak]

@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

[Anonymous]

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,

[lbendlin]

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.