+ Reply to Thread
Results 1 to 4 of 4

pivot table from PowerPivot Source showing rows only if theres value

  1. #1
    Registered User
    Join Date
    08-04-2020
    Location
    israel
    MS-Off Ver
    2016
    Posts
    8

    pivot table from PowerPivot Source showing rows only if theres value

    Hi,
    I have created a pivot table based on power pivot model.
    I have many rows and columns in the data source all of them are text beside one column that has values in it.
    when i am creating the pivot table the pivot is showing only the rows that have values in it.
    rows the the the column with the values doen't not have any values in it are not showing in the pivot table.
    how can i fix it and make the pivot to show the rows that does not have any values in it.
    Thanks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: pivot table from PowerPivot Source showing rows only if theres value

    In the attached file, the pivot table, based on a data model, illustrates not so much a solution as a work around:
    In the source data place zeros in the cells that don't have values,
    For the Value column of the pivot table set the field setting > Number Format > custom > 0;-0;;
    For future reference, you will usually get faster responses if you provide a sample file (instructions are in the banner at the top of the page).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    08-04-2020
    Location
    israel
    MS-Off Ver
    2016
    Posts
    8

    Re: pivot table from PowerPivot Source showing rows only if theres value

    Thanks a lot! i'll try attaching a file to the next question

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: pivot table from PowerPivot Source showing rows only if theres value

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] My pivot table is not showing the same values as the source data
    By heytherejem in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-26-2018, 08:25 AM
  2. PowerPivot number of rows LIMITATION (in pivot table)
    By George_1990 in forum Excel General
    Replies: 2
    Last Post: 01-20-2017, 06:43 PM
  3. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  4. [SOLVED] Pivot Table- Data no longer in table source still showing
    By Smally in forum Excel General
    Replies: 7
    Last Post: 09-10-2014, 11:23 AM
  5. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  6. Replies: 1
    Last Post: 07-07-2011, 11:17 AM
  7. Pivot table missing rows using PowerPivot
    By djgfx in forum Excel General
    Replies: 1
    Last Post: 04-06-2011, 01:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1