Forum Discussion
Showing issue in matrix problem
Hi!I I have a few months using PowerBI, but now I am facing an issue that at least in my mind should be very easy to solve but I cant find a solution that fill all my needs.
My dataset looks like:
| date | country | game_ver | platform | dau_total_users | mau_total_users | stickiness | sessions | installs | total_events |
| 8/9/20 | US | 2.0.1 | android | 24 | 101 | 0.2376 | 134 | 39 | 2411 |
| 8/9/20 | ES | 2.0.1 | android | 1 | 17 | 0.0588 | 1 | 12 | |
| 7/31/20 | DE | 2.0.1 | android | 6 | 27 | 0.2222 | 24 | 437 | |
| 7/30/20 | MX | 2.0.1 | android | 19 | 124 | 0.1532 | 94 | 1235 |
I just need to show it, but with DATES in columns (there are only last 15 days dates), and indicator in rows. Should look like:
| 8/9/20 | 8/10/20 | 8/11/20 | 8/12/20 | 8/13/20 | 8/14/20 | |
| dau_total_users | ||||||
| mau_total_users | ||||||
| sessions | ||||||
| total_events |
I tried drag and drop my values to a table/matrix graphs but it didnt work. Is is possible ? It should not be so complicated.
The only way that I found was using UnPivot Other Columns options, that indeed work ( page 2 of my pbix attached). But I want to avoid this data manipulation, because I also need to add some new calculations as indicatos ( for examploe, sessiones/users) and once I unpivot the dataset, the files converts in attribute/values combinations and I am not able to perform this calculations.
I am stacked.
I attached my .pbix as example if it helps
gustavo80 put dates on the columns and measures on the values, on format pane, select "Show on rows" and that will get you what you are looking for.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
gustavo80 put dates on the columns and measures on the values, on format pane, select "Show on rows" and that will get you what you are looking for.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Excellent, thanks for the immediate answer, it works!
I cant believe that I spent an entire day trying to fix it and there was an easy solution hidden there.
Thanks again, regards!
