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

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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

scottostanek's avatar
scottostanek
Frequent Visitor
1 year ago

I ran into a similar situation today and part of the problem is everyone kept focusing on replacing null with 0 or blank with 0. The value is not displayed because it isn't there to display. In may case it was a Category on the row and date on the column. I had empty spaces showing where there was nothing to count for a particular Category and date combination.

My solution was to use a new field in the orginal data ForCount =1
Then I generated all combinations of Category x Date with ForCount =0 and appended them. Instead of my original count I then displayed the sum(ForCount) --no more empty values.