Forum Discussion
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 anythnig in this field. I would like to summarise and keep all data on the table at the same. Some images below to illustrate better.
A screenshot from the table. I am looking to average the Final Project Status so this shows the average value at the bottom of the table. Not all rows contain final project status values.
When I set this field to average, BI automatically hides all the rows without any project status data. However I would like to keep all data in view, and average the status values shown (ignoring blanks). I can't seem to find a way to prevent the automatically hiding of the blank status rows. Filtering is still set to show all. Any ideas?
5 Replies
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?
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
