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

       

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

        Hi,

        please try to share Onedrive link, Googledrive link, Dropbox link, or any other link that allows to share the file, instead of attaching the file to here.

        Thanks.