CODEWITHSUNDEEP
powerbilinegroup
Alex
Alex

Reputation: 59

Power BI : line grouping

I begin to use Power BI, and I don't know how to group lines. I have this kind of data :

api   user  01/07/21  02/07/21  03/07/21 ...
a     25    null      3          4
b     25    1         null       2
c     25    1         4          5
a     30    4         3          5
b     30    3         2          2
c     30    1         1          3

And I would like to have the sum of the values per user, not by api and user

user  01/07/21  02/07/21  03/07/21 ...
25    2         7          11
30    8         6          10

Do you know how to do it please ?

Upvotes: 1

Views: 44

Answers (1)

iceblade
iceblade

Reputation: 641

I created a table with your sample data (make sure your values are treated as numbers):

Table

Then create a Matrix visual, with "user" in Rows and your desired columns in the Values section:

Matrix

Upvotes: 1

Related Questions