use two columns at the same time

[maca128]

Hi experts,

I am trying to display this:

But, like:

So far, I :

Created a matrix with:

-Rows: MemberID

-Columns: Metric Name, Completed Date

-Value: Units Passed

My problem now is that:

For Columns: Metric Name, Completed Date

 I get either by month or by metric name, and I need both at the same time as my screenshot above...

I was hoping to see some sort of 'combine' option here but there isn't.

 

[kcantor · Accepted solution]

You should be able to complete this by using the drill down by column and moving to the next complete step in the heirarchy.

Instructions can be found here: https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual

[maca128]

Even though I set to show all months:

In the results for example, I see only ‘march’ and ‘april’, why is that?

[v-shex-msft]

HI @maca128,

When you use matrix visual, it will auto hide whole row/column which only contains blank value or not real existed in table.

For this scenario, it is impossible to expand these non existing records to matrix.

You need to create a calculate table with the original records and expand the blank records, then you can use the new table to create the matrix visuals as expected.

Regards,

Xiaoxin Sheng