Forum Discussion

kanth999's avatar
kanth999
Helper I
1 year ago

Matrix visual export to excel getting grand total values.

Hi Team,   I have PowerBI Matrix visuals in that visulas it is not showing the grand totals but when i export to excel grand total values are coming. we don't want those grand total values in excel...
Need Help
kanth999's avatar
kanth999
Helper I
1 year ago

Hi Shahariar,

 

I have tried this option, but it don't work. 

  • shafiz_p's avatar
    shafiz_p
    Super User
    1 year ago

    Check this limitation:

    If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data contains subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu.

     

    Hope this helps!!