Looking for help Simplifying my table in Power BI

[Anonymous]

Hey all,

We are currently trying to clean up the look of our table. Ill Creat an example of what it looks like now with a table and how we want it to look. We have tried the matrix view and this has not worked for us either.

Bobby	Milk
Bobby	Eggs
Bobby	Bread
Mary	Peppers
Mary	Ketchup

 and we want the table to do this.

Bobby	Milk
	Eggs
	Bread
Mary	Peppers
	Ketchup
	Juice

Obviously this is a very simplified example but any insights will help

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

If you only want static display, you can create a condition column.

col3 = 
var r_ = RANKX(FILTER('Table',EARLIER('Table'[Column1])='Table'[Column1]),'Table'[Column2])
return IF(r_=1,'Table'[Column1],BLANK())

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TheoC]

Hi @Anonymous 

Use the Treemap visual:

Then go to Filter and select Stepped Layout on:

Hope this helps 🙂