Matrix Columns

[Anonymous]

Hi. Is it possible to make a matrix like this?

The column Customers is a measure from one table and New Customers come from other table.

I need only New Customers display in the table by date. Customers no.

Is it possible?

Thanks

[TomMartens]

Hey @Anonymous ,

unfortunately there is a quite simple answer: No.

@marcorusso created this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=49ca8e3e-efc4-ea11-bf21-281878bd39b4

You might upvote the idea.

Regards,

Tom

[Greg_Deckler]

@Anonymous and @TomMartens - There is a possible way of doing this, in your case the only variation would be you would have to have an "extra" parent in your hierarchy to your one customer value. I created this specifically for this circumstance:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

[TomMartens]

Hey @Anonymous ,

I have to rephrase my former answer, unfortunately there is no easy and no good solution.

If you can live with the 2-rows header for the customer measure you can adapt the solution provided by @Greg_Deckler .

Regards,

Tom 

[Greg_Deckler]

@TomMartens - I am 100% with you that I would not consider the custom matrix hierarchy thing anything resembling an easy or "good" solution to the problem. I ended up creating it after a long series of posts in a thread and it is inelegant and difficult and brutally manual/hard coded. It's one of those things that if you really just have to have it looking that way then it's a way to accomplish it. We really need a better way though!!