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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Libin7963
Helper II
Helper II

How to show in power bi visual

In Power Bi desktop tabel visual, my data is displaying as shown in table 1 below however I would like to display as in table2, please assist or any guidance on how I can will be helpful.

Libin7963_0-1725399609879.png

1 ACCEPTED SOLUTION
suparnababu8
Super User
Super User

Hi @Libin7963 

There are default options in Matrix chart to implement like this.

 

suparnababu8_0-1725427523352.png

This above table is your input table

 

suparnababu8_1-1725427558852.png

This is your output table. For this you have to drag all your columns in Rows section(pls see below)

suparnababu8_2-1725427635976.png

Then your matrix chart will show like this 

suparnababu8_3-1725427664650.png

 

Then you click drill down to lowerlevel, you will get the result as you expected.

suparnababu8_4-1725427706451.png

 

Thanks for bringing up this question.

 

View solution in original post

3 REPLIES 3
suparnababu8
Super User
Super User

Hi @Libin7963 

There are default options in Matrix chart to implement like this.

 

suparnababu8_0-1725427523352.png

This above table is your input table

 

suparnababu8_1-1725427558852.png

This is your output table. For this you have to drag all your columns in Rows section(pls see below)

suparnababu8_2-1725427635976.png

Then your matrix chart will show like this 

suparnababu8_3-1725427664650.png

 

Then you click drill down to lowerlevel, you will get the result as you expected.

suparnababu8_4-1725427706451.png

 

Thanks for bringing up this question.

 

Anonymous
Not applicable

Hi vicky_ ,thanks for the quick reply, I'll add more.

Hi @Libin7963 ,

There may not be a direct way to achieve your needs. I think you can use DAX to indirectly achieve your needs, as long as the amount of data here is not too much. If the amount of data is too much, it will be displayed abnormally in the visual.

vzhouwenmsft_0-1725416085549.png

You can use the 'CONCATENATEX' function.

CONCATENATEX function (DAX) - DAX | Microsoft Learn

 

Colour_code = CONCATENATEX('Table',[Colour code],UNICHAR(10))
Colour_ = CONCATENATEX('Table',[Colour],UNICHAR(10))

 

vzhouwenmsft_1-1725416231754.png

 

Best Regards,
Wenbin Zhou

vicky_
Super User
Super User

I don't think you can get 100% of the way there with the default visuals, but you can get pretty close by using a Matrix visual, and then changing the Style to Outline: https://www.linkedin.com/pulse/new-power-bi-matrix-layouts-pbicorevisuals-cr1if and  then keep expanding all the way down to the Colour level of your heirarchy.

vicky__0-1725401959605.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.