Forum Discussion

RM_1's avatar
RM_1
Frequent Visitor
5 years ago

Double text axis using horizontal bar chart

Hello Power BI lovers,

I try to create horizontal bar chart, which contains two text axis, like on below screenshot designed in excel:

I've created table like this:

IMO, there is no simple way to create such visual, so I used formula like this (of course it's simplified): 
SWITCH(TRUE(),Order = 1,"1st Phase",Order = 2,"2nd Phase",Order = 3,"3rd Phase",Order = 4,"4th Phase")

and still no results. 😞 Can anyone help with this? I spent whole day to find out, how to solve this.
Thanks

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    RM_1 you need to look for a custom visual that allows for two columns to be used on x and y axis. 

     

    Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • RM_1's avatar
      RM_1
      Frequent Visitor
      5 years ago

      Can you recommend such visual? I couldn't find anything like this

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi RM_1 ,

     

    There's a workaround. You can do this by creating a bar chart and a text box.

     

     

    You can check more details from here.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • RM_1's avatar
      RM_1
      Frequent Visitor
      5 years ago

      Hi Stephen, thanks. I know, I did it like this but there are some issues with this approach, when having not so much space for this visual on the page:

      1. you need to set white background of those text boxes and cover x-axis, otherwise you will not see vertical lines indicating progress,

      2. white text box background when limited space on the page causes some parts of white boxes outside of chart area, otherwise you will see scroll on each text box,

      3. using other screen resolution may cause a little bit of mess in there,

      4. max letters height in text box = 8, while I have 6 on the y-axis, not look so good even using "card" visualization

      This is why I'm looking for solution, not workaround. 🙂