Power BI Transpose Report data

0
votes

I have this data in excel that I imported into Power BI

Area    Attach  Pay Start   Entry
North    1       0   1       0
North    1       0   1       0
North    1       0   1       1
North    0       1   1       0
West     1       0   1       0
West     1       0   1       1
West     0       0   1       0
West     1       1   1       0
West     1       0   1       0
West     1       0   1       0
West     1       0   1       1

I produced a report using matrix and sum the values of Attach, Pay, Start and Entry then group by Area

My current output

enter image description here

My Desired Output

enter image description here

i can do the formatting dont worry about it

1
reportpowerbi
i recommend you to do in in query designer before you do it in powerBi – PV8

1 Answers

3
votes

There is a show on row option in formatting pane:

enter image description here