Forum Discussion
Row with blank value disappear from table
My data model consists of three tables:
- a table with all sales staff
- a table with records of all sales
- a calendar table
When I create a visual with all staff for a sales period Power BI returns 11 names, which is correct:
However, when I add the total sales for the sales people, three sales staff with no sales for the period drop off:
Any idea how I can include these in the table with showing just a blank field for sales? The are currently no filters applied to the visual other than the date of sale.
Thanks
Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:
Measure = VAR __Calc = <Some calculation> RETURN IF(ISBLANK(__Calc),0,__Calc)
5 Replies
Make sure that the table field is set to don't summarise, otherwise having a blank value will cause the whole row to disappear.
- amitchandak
Super User
Anonymous , You can Use +0 and filter for =0
or use this option
Thanks for your suggestion amitchandak. However, the field I was pulling did not show the "show items with no data" option.
- Greg_Deckler
Community Champion
Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:
Measure = VAR __Calc = <Some calculation> RETURN IF(ISBLANK(__Calc),0,__Calc)Thanks Greg_Deckler, your answer worked like a charm.
