Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RE: same as Excel pivot in PBI

Hi all,

 

i want to show pivot in powerbi same as excel.  im unable to get the same 

 

orignal-

can anyone help on this?

 

PBI.  i need same as above.

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi Anonymous 

     

    Use a Matrix Visual and turn on the +/- icons from Row Header section

     

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

     

    Use a Matrix Visual and turn on the +/- icons from Row Header section

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thank you. i want to give colour to total row. i didnt find the option for this :(

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous 

         

        There is a "Grand Total" section as well.

         

        You can change background and font colors from there