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

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    it is changing to  column wise totals and row wise totals also :(  i want row wise total colur should be changed