Forum Discussion

SimpoPower's avatar
SimpoPower
Helper I
6 years ago

How to not hide rows in a table when summarising fields?

Hello, I have created a table of data in Power BI Desktop.  I want to summarize some values in the table.  However when I set a value to summarize, BI automatically removes the rows that don't have a...
Need Help
ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi SimpoPower 

open the menu for field "Project Name" and select "Show items with no data"

 

SimpoPower's avatar
SimpoPower
Helper I
6 years ago

Great, thanks Imke. 

 

Now that I set the summarisation to average, Power BI automatically adds 2 decimal places to all my values now.  In my original data I have no decimal's applied.  Is there anyway to adjust the decimal's in the table viewer?  

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi SimpoPower 

    Hm, that sounds like a bug to me. But you can try to explicitly set the format of your measures and columns in the Modeling tab.

    Check the measure definitions or column names (in the data view) and adjust settings under Modeling -> Formatting

     

    • SimpoPower's avatar
      SimpoPower
      Helper I
      6 years ago

      Imke,

       

      Yes, seems to be a bug.  When I set the decimal's to 0 in the formatting tab, it always reverts back to 2 decimals.