Feedback by UserVoice

Kenneth Barber

My feedback

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    This should only be when you are adding the table to a new worksheet.

    Kenneth Barber supported this idea  · 
  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    I agree with the colouring part of this suggestion. The "Merge & Center" part of this suggestion can be gotten using Center Across Selection alignment.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    What are you talking about? Can you attach a screenshot in a comment?

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In what case would you want to read Power Pivot data into VBA? Power Query lets you code in DAX, so I'm curious as to what you would need that is only available in VBA.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    What do you mean by "breaks"?

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Do you mean the "Change Data Source" button in the PivotTable Analyze tab that appears when a PivotTable cell is selected?

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I think that a better approach would be to add a separate line for the source table. The table name and the column name might be long, so there might not be enough room if they are on the same line.

    Kenneth Barber supported this idea  · 
  8. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Workaround: to the Data Model, add tables whose only purpose is to hold measures. This effectively groups measures together and makes them easier to browse.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Instead of trying to put subtotals into a Power Query table, why not add the table to the Data Model and create a PivotTable (which supports subtotals) based on that Data Model table? You wouldn't even need to add your Power Query table to the sheet if you don't want to.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Not every source table is on a sheet. A source table can come from a database, CSV file, another spreadsheet, etc.

    It is generally bad practice to spread out important information across cells, formatting, text boxes, comments, etc. Because there is no consistency in the way that the data is represented, you need to analyze each representation differently. Instead of using cell colour as a carrier of meaning, add a new column and enter the meaning in this column's cells.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    What kind of data source (data on a sheet, data gotten using the Data Connection Wizard, data gotten Power Query)?

    Let's not forget that if there was a "refresh these columns only" feature wouldn't work so great if you also inserted or deleted rows. The inserted rows would not be able to show until all columns are refreshed, and deleted rows would not be allowed to disappear until all columns are refreshed.

    A more general feature request would be "track changes since the last PivotTable refresh to speed up the next refresh".

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    That link doesn't work anymore.

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    This should be retitled to "Be able to add a histogram PivotChart".

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You're right. If you try this when on a field that is along the rows or columns, the PivotTable is empty. It is only when the field is part of "Filters" that a random ID is picked instead of showing an empty PivotTable. Also, the singular of "criteria" is "criterion".

    Kenneth Barber supported this idea  · 
  15. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    UserVoice lets you attach files in comments. Can you attach a workbook or screenshot that shows what you are trying to describe?

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    This issue seems to be fixed. You can use the DAX functions MIN and MAX against a date column, and you can create an implicit measure that takes the minimum or maximum value in a date column.

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  19. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In what case would you need to remake a PivotTable each time you have new data? Why not just update your existing table and refresh your existing PivotTable that is based on that table?

  20. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 

Feedback and Knowledge Base