Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 retu...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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)
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , You can Use +0 and filter for =0

or use this option

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your suggestion amitchandak. However, the field I was pulling did not show the "show items with no data" option.