Forum Discussion

IlseV's avatar
IlseV
Frequent Visitor
4 years ago
Solved

how to replace blank fields to zero in matrix visual

Hi I have a table Itemnumber      Date                    Value        A 12/09/2022 20 A 13/09/2022 50 A 14/09/2022 60 B 13/09/2022 40 B 14/09/2022 10 C 12/09/2022 ...
Help Request
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

     

    Hi,

    thank you for sharing.

    In my opinion, data model has to be created by using item dimension table and date dimension table.

    Please check the attached pbix file and the below picture.

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

One of ways to achieve this is to create a measure something like below, and put it into the matrix visualization.

 

New measure: = SUM(Table[Value]) + 0

 

 

  • IlseV's avatar
    IlseV
    Frequent Visitor
    4 years ago

    Hi, I already tried this, but it doesn't work. The blank fields still remain blank.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Thank you for your feedback, and please share your sample pbix file's link here, and then I can try to look into it to come up with a more accurate solution.

      Thanks.

      • IlseV's avatar
        IlseV
        Frequent Visitor
        4 years ago

        Hi, I can't add pbix files here