Forum Discussion

Anonymous

Not applicable

5 years ago

Matrix Columns

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 b...

Super User

5 years ago

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
Community Champion
5 years ago
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
  Super User
  5 years ago
  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
    Community Champion
    5 years ago
    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!!