Want to split a table up by a dimension

[Anonymous]

Hi - I am pretty new to Power BI, and am using desktop. 

I want to create a chart like the first one below which shows the number of new clients by year, but which also splits the data up by office. In Power BI, I see that I can add Office to Legend, and that gets me a lot of colored bars, but it's hard to read. I prefer a setup like the one below, where each office has its own pane. It's easier if each office can view their yearly data side-by-side. 

Is this possible in Power BI? 

Thanks!

What I want, which was created in Tableau

What I've got, which was created in Power BI

[mwegener]

Hi @Anonymous ,

is your problem solved?

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[v-chuncz-msft]

@Anonymous 

You may also try Drill down in a visualization in Power BI and take a look at this post.

[mwegener · Accepted solution]

Hi @Anonymous,

how about if you swap legend and x axis?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.