stacked bar lables visibilty

[erezb]

a combination of 2 deseases

Hello

I've made a staked bar graph showing number of  cases in each medical disease.

I've limited this to paitens with up to a 5 diseases .

I have also have a filter from which  I can choose a number from 1 to 5, reffering to the number of disease in a each combination.

However when I go to the cases with more than one desease (2-5) the x axis lables are not clear.  the picture I have attached  is for 2 disease in a combination however it becomes worse when i choose a highr number.

If it were excel I could have made the disease names written one after the other in the same cell(ctrl+enter)' and that would fix the problem, however here the only soloution came into my mind is to split the text (each desease separated by a + sign) and build a new string with concatenate,  but it didn't work out. I managed to split the string but not build a new correct one.

if there was a way that the lables could be like that:

disease a+ (line feed+

disease b+ (line feed)+

disease c

....

up to 5 diseases.

Does someone have an idea how to implement this?

Thanks in advance

Erez

[v-jiascu-msft]

Hi Erez,

Did you use the built-in visuals? Or R visual? It seems fair in my test. How did you combine the labels? Please vote on idea here. 

Best Regards,

Dale

[erezb]

Thanks for your reply v-jiascu-msft.

I've used the same slicer as you did.In your graph x-lables seems as I am tring to achieve. My data is located in an sql table I've imported into power Bi.No R is involved here.

One of the fields in this table is the combination fields.The disease combination is concatenated with the '+' character , I.e for an id that  has 3 diseases it will be - disease1+disease2+disease3, up to idd holding 5 diseases. The concatenation is done in sql.

Each row in this table corresponds to id fiels also located in the table, One row for each Id and of course as mentioned the combination fields and together with fields  (cost, etc).

id      disease's combination disease ,                 number of disease ,cost and so on.....

1       disease1+disease2+disease3                        3                          1000

2       disease1+disease2                                        2                           1300

2       disease1+disease2+disease3+disease3        4                           2,000

 Is there a solution? Maybe to split the combination and build it again inside Power-Bi.

Thanks again

Erez

[v-jiascu-msft · Accepted solution]

Hi @erezb,

The easiest solution could be using spaces instead of "+". You can check out it in this file. Remember to change the width of the category.

Best Regards,

Dale

[erezb]

Thanks v-jiascu-msft

It works fine now.