cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oguedda
Helper I
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

oguedda_0-1608826163426.png

 

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 : 

oguedda_1-1608826325620.png

 merci d'avance pour votre aide,

1 ACCEPTED SOLUTION
oguedda
Helper I
Helper I

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

oguedda_0-1609149866853.png

and the result was:

oguedda_1-1609149951802.png

 

problem solved,

View solution in original post

6 REPLIES 6
oguedda
Helper I
Helper I

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

oguedda_0-1609149866853.png

and the result was:

oguedda_1-1609149951802.png

 

problem solved,

View solution in original post

oguedda
Helper I
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.

oguedda_0-1609147846970.pngoguedda_1-1609147890518.png

 

I would like it to show me the option not to summarize for the data "note".

RicoZhou
Community Support
Community Support

Hi @oguedda 

In addition to  

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.

1.png

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. 

amitchandak
Super User IV
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/

https://www.youtube.com/watch?v=M5PvQUy-L_4

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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
Super User III
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.

 

lbendlin_0-1608827235579.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.