Power BI Exchange

Expand all | Collapse all

Subtotal row labels in matrix

  • 1.  Subtotal row labels in matrix

    Posted Jan 11, 2019 03:42 PM
    Hello,

    I apologize if this has been answered in another post, but I'm wondering if it is possible to include the actual name of whatever is being subtotaled in the subtotal line. In the example below, rather than just "Total" repeating for each section, it would be much more clear if it said "Total Revenues", "Total Cost of Sales", "Total Expenses", etc. As this is currently formatted, the "Total" for revenues and the header "Cost of Sales" appear to be the same field at a quick glance. Adding the description to the total would be very helpful!

    Thanks.

    subtotals

    ------------------------------
    David York
    Allagash Brewing Company
    Portland ME
    2078785385
    ------------------------------


  • 2.  RE: Subtotal row labels in matrix

    Bronze Contributor
    Posted Jan 14, 2019 03:09 AM
    This is not possible currently, so please vote for it here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36031306-when-showing-subtotals-at-the-bottom-show-the-att

    And to make your P&L really look nice, you should also vote for this feature: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in

    But if you're happy with typing in your aggregation logic manually into each visual, maybe this custom visual is for you: https://appsource.microsoft.com/en-ca/product/power-bi-visuals/WA104381971 

    ------------------------------
    Imke Feldmann
    MVP Data Platform (Power BI)

    www.TheBIccountant.com



    ------------------------------



  • 3.  RE: Subtotal row labels in matrix

    Posted Jan 14, 2019 06:17 AM
    Thank you, Imke. I cast my vote and will definitely check out the custom visual you suggested.


    ------------------------------
    David York
    Allagash Brewing Company
    Portland ME
    2078785385
    ------------------------------