Show all Buckets in a Matrix

[comish4lif2]

I have a Matrix visual, and along 1 axis, I have a count of HCCs, But not every count has a value, so, Power BI skips the row. For example below, 11 and 14 are skipped. Is there a way to force the matrix to show a row even when there is no data to display?

In the dataset, in that column, all values from 1-15 do occur. As I filter the data, there are buckets/values that have no IDs and the count is 0. The Matrix then skips that row value. I want to show a blank row even when the value (count) is zero; showing the row  for all rows. Is this possible.

Right clicking and selecting "Show Items with No Values" has no affect on my visual.

[v-cgao-msft · Accepted solution]

Hi @comish4lif2 ,

There is no setting like continuous axis in the matrix. You may consider creating two new tables to fill in the missing values of the axes and pass these values into the formula via variables.

Suppose we have a table like this.

We can create two tables that are not connected:

Table 2 = GENERATESERIES(1,5,1)

Table 3 = GENERATESERIES(1,5,1)

Then drag them into the matrix, at this point the matrix will report an error and we will ignore it for now.

Then please new a measure and use it as matrix's value. like

Measure = 
VAR _x = MAX('Table 2'[Value])
VAR _y = MAX('Table 3'[Value])
VAR _value = CALCULATE(SUM('Table'[Value]),'Table'[X]=_x&&'Table'[Y]=_y)
RETURN
_value

And check the show items with no data, result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Mahesh0016]

plz provide demo data .

[comish4lif2]

No. My work data is sensitive.
Is the concept that hard to understand?