Forum Discussion

lostmail's avatar
lostmail
New Member
5 years ago
Solved

BI Matrix (Pivot)

Hi, I´m newbie in BI and playing around some with it....got my first reports but i`m stucking here to format the (pivot) matrix.

I have 3 fields in the table which should be side by side and not "stepped"....In Excel Pivot I know where the option is to modify the pivot layout but I can not find it in Power BI

Any sugg. where I can modify it ?

 

Thanks all.

Need Help
  • lostmail's avatar
    lostmail
    5 years ago

    Ah got it - subtotals "per row level" activated....rocks...

     

    Thanks guys for your inspiration ! I´ll come back 😁

6 Replies

    • lostmail's avatar
      lostmail
      New Member
      5 years ago

      Ah - thanks..got it.

      But this is a layout option which takes effect for all fields....and i have no subtotals for each line...

      Is there a way to decide which line has subtotals or not ?

      I can only switch it on or off ?

      • negi007's avatar
        negi007
        Community Champion
        5 years ago

        lostmail  +/- icon will appear against a value which has a low level hierachical value in the matrix visual. This indicate that it has low level hierachical value or upper level value to view or hide it.