Forum Discussion

Paco's avatar
Paco
Frequent Visitor
9 years ago
Solved

Fill Gaps in Matrix

I want to fill with 0 when there is no value, how can I do it?      
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Paco

     

    You can try using a Measure:

     

    MyMeasure=sum(Table[YourField])+0

Paco's avatar
Paco
Frequent Visitor
9 years ago

I am using a data from SQL Query, so I can´t add or I dont know how to add rows with 0. 

 

What I want to do is something similar to a pivot table in Excel "For empty cells show" with this option in excel I resolve this but I dont know how to do it in Power BI

 

 

 

 

don 

 

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Paco

 

Hi, What are using in Values Section in The Matrix?.

 

A Field, a measure?

 

 

 

 

  • Paco's avatar
    Paco
    Frequent Visitor
    9 years ago

    A field

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      Paco

       

      You can try using a Measure:

       

      MyMeasure=sum(Table[YourField])+0

      • Paco's avatar
        Paco
        Frequent Visitor
        9 years ago

        Thank you very much, it has been solved