cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
candicehan
Frequent Visitor

How to extend the hierarchy horizontally?

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

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

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 LevelContinnent LevelCountry LevelCountry LevelCityLevel.PNG

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

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

Greg_Deckler_0-1600891102021.png

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Greg_Deckler
Super User IV
Super User IV

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

Greg_Deckler_0-1600891102021.png

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors