Showing issue in matrix problem

[gustavo80]

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

https://wetransfer.com/downloads/09f7bef793eff5dec6fefaa7482d1f8620200812191911/a9935476ff45e02fb6da...

[parry2k · Accepted solution]

@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.⚡

[gustavo80]

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!