CODEWITHSUNDEEP
powerbidaxpowerquery
Zzema
Zzema

Reputation: 307

Work with matrix (I can't edit visualisation)

I have this table in Power BI, But I can't do another table. 1

How I can do this?

Now the values are grouped by date (different fields have information under one date, next the same fields are grouped by another date) I want the values in the columns to be grouped by field (one field has date information next to it).

Edit1: I can't set Date on the 2nd place in the grouping

2

Because date is column, traffic,orders,rev,costs- are values

Upvotes: 2

Views: 183

Answers (1)

Eugene
Eugene

Reputation: 1264

You need to set Date on the 2nd place in the grouping, after a field containing traffic, orders, etc.

EDIT:

You need to unpivot these columns first, for example, in PowerQuery. Use Edit Query. This results in transforming your 4 columns to 2: Attribute and Value. Attribute will be your first grouping parameter. 2nd will be Date. Value column goes to values.

If you need your source query somewhere else, you may create new query for this very report only. It is done by first right-clicking original one and selecting Reference Query, and the doing any edits. This will keep original query intact.

Upvotes: 2

Related Questions