Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

No data presented where no rows exist

We are looking to have a PBI where it shows every day in the row (1-31) with categories as columns (cat1, cat2, cat3 etc) then a count of every item and if no sales were made then show 0. (see curren...
Need Help
  • pforrer7's avatar
    pforrer7
    6 years ago

    Hi Anonymous,

     

    If you don't have a Category table create one and relate it, then show the new category field on the columns of the matrix and then build a count measure like this one:

     

     

    Item count = COUNT('Table'[Item])+0

     

    Note the +0 at the end, which makes Power BI show zeros where there is no data.
     
    Let me know if this works for you.
pforrer7's avatar
pforrer7
Frequent Visitor
6 years ago

Hi Anonymous,

 

If you don't have a Category table create one and relate it, then show the new category field on the columns of the matrix and then build a count measure like this one:

 

 

Item count = COUNT('Table'[Item])+0

 

Note the +0 at the end, which makes Power BI show zeros where there is no data.
 
Let me know if this works for you.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    pforrer7  thank you! 😊