Forum Discussion

croberts21's avatar
croberts21
Icon for Continued Contributor rankContinued Contributor
3 years ago
Solved

How to NOT automatically do subtotals on numeric fields in a table?

I have PBI Desktop from March 2023.    When I make a table and drag a numeric field to it, by default PBI sums the numeric field. This makes the value in every row incorrect. So a Fiscal Year tha...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  croberts21 ,

    Sorry, this feature is not available in Power BI at the moment

    You can find it in the model view.

    Use ctrl key to select multiple columns.

    Advanced - Summarize by -- Nonez to set the operation summary. Afterwards, reposition the columns in Visual, which saves a lot of time compared to row-by-row.

    You can also submit an idea for it at https://ideas.powerbi.com/forums。

    And here are the same similar Idea information for you to see:Microsoft Idea (powerbi.com)

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  croberts21 ,

Sorry, this feature is not available in Power BI at the moment

You can find it in the model view.

Use ctrl key to select multiple columns.

Advanced - Summarize by -- Nonez to set the operation summary. Afterwards, reposition the columns in Visual, which saves a lot of time compared to row-by-row.

You can also submit an idea for it at https://ideas.powerbi.com/forums。

And here are the same similar Idea information for you to see:Microsoft Idea (powerbi.com)

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.