Forum Discussion

aj1107's avatar
aj1107
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Display zero instead of blank in matrix

  Need to dsiplay zero  instead of blank in matrix. Though it looks simple, am struggling to get it done. Heres the sample record.   id,name,status 1,a,s 1,b,h 2,d,s   Output in power bi. Nee...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    aj1107

     

    Hi, you can obtain this view following these steps:

     

    1.Create a new Table (Modeling-New Table)

     

    Tablepr=Distinct(Table1[pr]

    2. Related both tables

     

    3. Create the Measure to Count IDs

     

    CountIDs=Count(Table[id]) + 0

     

    Ready

     

    Matrix Visual

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

   I badly need help with a slightly different scenerio. I am trying to show values within a matrix and replcae blank values to 0 and there ia also an option to be provided for the client to extract underlying data. using the solution shared here by vvelarde blanks are being replaced to 0 but my excel extract is not filtering the data accordingly (Bth the tables are related).

Is there any other way to acheive 0 instead of blanks in matrix and allowing the client to extract underlying data.

 

Thanks in advance.😊