cancel
Showing results for
Did you mean:
Helper I

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

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,

1 ACCEPTED SOLUTION
Helper I

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

and the result was:

problem solved,

6 REPLIES 6
Helper I

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

and the result was:

problem solved,

Helper I

Hello @amitchandak @lbendlin and @RicoZhou ,

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

Community Support

Hi @oguedda

``Month Year sort = YEAR(Sheet26[Date])*100+MONTH(Sheet26[Date])``

``Month-Year = FORMAT([Date],"mmm-yy")``

My Sample Table is as below.

Sort Month-Year by Sort column like

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.

Super User IV

@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

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

Proud to be a Super User!

Helper I

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,

Super User III

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.

Announcements