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.

     

     

     

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.