Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone, I am new to Power BI and I wanted to know if it is possible to make a matrix similar to the following image
The matrix should have a "Plataforma" column which should be grouped by the "Layer" column and in another column there should be, for example, the "NivelCta1" column, now try to do the following:
but I see values in the column "NivelCta1" in the row "Enablers", "Finance Management", etc. when those values should not appear, and if those values should appear for "Layer"
playing a little I managed to get this, and the next level in "Layer" goes wrong and I don't get the data for the column "NivelCta1" either
As you can see in the blue row of "Enablers" it does not have values and in the red row of the "Layer" column it does have values in the following columns
this is my data source
I hope someone can help me, thank you very much
here I share the files
pbix file
https://1drv.ms/u/s!AricA4d57I9qpFjl5USADQZnVFss?e=788vUV
Excel file of how I would like the matrix to be displayed in power BI
https://1drv.ms/x/s!AricA4d57I9qpFkCcXnGcCjQ_wAQ?e=ozTo41
Hi @ext_jcardenas ,
Could your please provide your pbix file without privacy information and desired output with more details?
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
here I share the files
pbix file
https://1drv.ms/u/s!AricA4d57I9qpFjl5USADQZnVFss?e=788vUV
Excel file of how I would like the matrix to be displayed in power BI
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
147 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |