Power BI Ideas

  • Vote for an existing idea (1267)
  • or
  1. matrix remove grand total rows

    There is currently an option to turn on/off subtotals at the row or column level, however for grand total this is not an option. Please give the option to turn on or off grand totals for either row or columns.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  2. % of Row / Column / Grand Total in Power BI Service

    It would be great if PowerBI service could also support calculation like
    "Show value as % of Row / Column / Grand Total "
    just like in desktop.
    It's a basic thing, customer asks when are using Self-service BI in service.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  3. Toggles for Sub-Totals and Grand-Totals on Matrixes

    We can now turn Row Totals on or off, and that turns all subtotals and grand totals on or off. It would be great to be able to have the option to have the Grand Totals on without the subtotals, or have the subtotals on without the Grand Totals.

    90 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  4. 39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix Grand Total Visualization

    It would be useful to choose if i want to see the Grand Total Row at all time, whether im going up or down on a large matrix.

    I have the problem that if i am looking at the firsts rows, and want to see the grand total i should go all the way down at the end of the matrix, and then go up all the way again.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  6. Matrix/Table grand totals with Measures

    It would be great if Grand Totals on a Matrix or Table would add up correctly to the sum of the rows when you include MEASURES in the visual. Currently the total on a measure consists of the measure function itself, instead of the sum of the rows above. PLEASE give us the option to toggle totals to be a simple aggregate of the rows above also.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. Grand total

    Grand totals currently return the measure at a Total level. So sometimes the value is incorrect as it is not an aggregate of the values in the table. PowerBI should at least give the option to calculate the Sum, Average, Weighted Average or Measure Calculation for the Grand Total.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  8. Calculating options for totals - Sum of rows or Measure Totals

    PowerBI Needs the option to allow a user to easily change the Total calculation via dropdown or toggle switch.

    - Sum of visible rows
    This should be the default since this is what a user expects in most cases.
    If I create a measure in a If Statement for Product A which is a sum + 10% AND an expression for Product B which is the usual Sum
    My totals are Incorrect!! :| I need to code for the total row! :(

    You could go a step further an provide selection options for:
    Sumx, Avgx, minx, maxx…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  9. Display Tooltip over Grand Total

    Please allow the ability to have a tooltip appear over a grand total field in a matrix. It works fine for values and subtotal, but not for grand totals. A workaround for now is artificially creating a subtotal category, but this is cumbersome.

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  10. display grand total when TOP N used

    In a grid, I want to display the grand total ignoring the TOP N setup in the grid.
    like my top 20 customers, but the grand total I want all the customers, not only the total of the top 20

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  11. Matrix Row Total Hide Zero

    Hide Row when Row Total is Zero in Matrix Visual

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  12. % of row total

    Please add % of row total to clustered columns, as it is I have to export data to Excel and build a pivot table to graph. 100% stacked columns won't work for what I'm trying to show, I need the % of row total.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  13. Turn on Select Sub Totals and Grand Totals

    Right now when you select turn on grand total or subtotals it will total everything. Would be nice to be able to turn off some of the subtotals while keeping the others.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  14. show Row Totals without Subtotals [New Matrix]

    show Row Totals without Subtotals [New Matrix visual]
    currently you havez to display row subtotals if you want to see row totals

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  15. Ability to add grand total to column/bar charts

    It would be great to be able to add a grand total column/row to a column/bar chart. For instance, if I have four sales regions and I plot sales by region on a clustered column chart, I would like to be able to add a fifth column that shows the total for all regions. Similar to this functionality in Tableau: http://onlinehelp.tableau.com/current/pro/online/mac/en-us/calculations_totals_grandtotal_turnon.html

    419 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    34 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add category,value,% of grand total in bar graph

    Add category,value,% of grand total in bar graph

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  17. Conditional formatting in Total rows

    I think it would be great if conditional formatting coloured the Total Rows

    83 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  18. Grand total Header need to rename and align to left or right

    IN matrix grant total header has to be changed to something else example: Grand Total - Actual

    And There should be flexibility to change order of grand total position to left or right. Currently its fixed to right only.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  19. In Addition to 'Row Sub Totals' (Format control in Visualization), Would be nice to have a Total Avg. Row as well

    In Addition to 'Row Sub Totals' (Format control in Visualization), Would be nice to have a Total Avg. Row as well

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  20. Matrix Grand Total Sum

    For example, in my Matrix I have two columns that are multiplied together, creating a Quick Measure that I used for a THIRD column in the matrix. I would like the "Grand Total Sum" at the bottom to be the Sum of the values in the third column. However, right now the Total at the bottom represents the Product(multiplication) of the Sums of the first two columns.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 63 64
  • Don't see your idea?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.