Forum Discussion

EvaSkoldqvist's avatar
EvaSkoldqvist
Frequent Visitor
3 years ago

Horizontal Y axis alignment for bar chart with hierarchical data

I want to show horizontal bars for hierarchical data. The Y axis texts needs to be horizontally aligned to be legible.

 

 

Please note that the simplified data in this example does not have long strings but my actual data does. Power BI insists on having the first level vertically aligned making it impossible to read the longer texts.

 

I feel like vertical vs. horizontal alignment should be a basic setting that the user should be able to change. If it is not then does someone know if there is a custom visual available that can show a simple hierarchy and some numbers? I have tried to find something but the 2-3 available vizuals are not fulfilling this simple need. ğŸ˜”

Need Help

2 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    You can concatenate the axis labels. In your example, it would look like
    Category A Item a

    Category A Item b

    and so on...

     

    • EvaSkoldqvist's avatar
      EvaSkoldqvist
      Frequent Visitor
      3 years ago

      Sorry. I forgot to mention that concatenating axix labels won't work.

      Each row on the axis will be repeated which makes it look very messy. Since the strings are a bit longer you would also only see the beginning of each level 1 label, no level two level will be visible unless I make the graph ridiqulously wide.

      I am hoping for another solution. 🙂