Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@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:
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
@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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |