Forum Discussion

cg1980's avatar
cg1980
Icon for Helper I rankHelper I
5 years ago

Display zero for rows and Columns with no data in a matrix

Dears, we use  a 4 X 4 matrix to report number of incidents per 2 impact dimensions ( figure 1)

the data set key data points are below,  this is easy to achieved using a matrix in Power BI,

 

Issue ID

Impact 1

Impact 2

1

Low

High

3

Low

High

Xx

 

 

 However there are times that the filtered dataset does not contain one of the expected Impact types, ( either column or Rows)  when that’s the case, our matrix , will display as in Figure 2  , where what we want to achieve is the Figure 3

 

Could you recommend any approach to sort this out ? Any alternative or suggestion would be greatly appreciated.

 

5 Replies

    • cg1980's avatar
      cg1980
      Icon for Helper I rankHelper I

      Hi themistoklis thanks for checking! , This wont work because the Impact category  is not part of the filterd dataset., power BI is using to create the matrix. Make sense? 

      • themistoklis's avatar
        themistoklis
        Icon for Community Champion rankCommunity Champion

        The reason they are not displayed is because they have NULL values (or Zero values)?