Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Want to split a table up by a dimension

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

  • 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.

3 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    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.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    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.