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.