How to extend the hierarchy horizontally?

[candicehan]

Text table from Tableau (This is what I want to get)

Matrix from PowerBI

I would like to replicate this table in PowerBI. The dataset contains hierarchy consisting of Continent, Country and City. When I use matrix visual in PowerBI, it gives drill-down feature but doesn't show all levels horizontally. Basically, data is showed in three visuals.

Continnent LevelCountry Level

How can I replicate the table structure in Tableau using PowerBI? Drill-down is a good feature in PowerBI. But showing all levels of data on one page also has its advantage. Please help me to solve this issue. Thanks a lot in advance.

[Greg_Deckler · Accepted solution]

@candicehan Use the first configuration and turn off stepped layout:

[kwabenaoasante]

Hello @Greg_Deckler i currently want to achieve this same structure with my hierarchy for a matrix visual so it expands horizontally however i do not see the stepped layout option under row headers in my power bi desktop version. 

[Greg_Deckler]

@kwabenaoasante What version are you on? I'm nearly certain that setting has been around for a while. Can you share a screen shot of what you are seeing?