Double text axis using horizontal bar chart

[RM_1]

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

[Anonymous]

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]

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

[parry2k]

@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]

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