Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
ext_jcardenas
Frequent Visitor

Show elements without data in an array

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

 

ext_jcardenas_1-1662667849042.png

 

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:

ext_jcardenas_2-1662668854860.png

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

ext_jcardenas_3-1662669099136.png

ext_jcardenas_4-1662669189550.png

 

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

ext_jcardenas_5-1662669268758.png

 

this is my data source

ext_jcardenas_6-1662669688536.png

 

I hope someone can help me, thank you very much

 

3 REPLIES 3
ext_jcardenas
Frequent Visitor

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

 

 

Anonymous
Not applicable

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

https://1drv.ms/x/s!AricA4d57I9qpFkCcXnGcCjQ_wAQ?e=ozTo41

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.