plotting, visuals,

[Anonymous]

Hi  everyone,

i have a table with (among others) the following fields:  country,  value_in %,  year.  In Tableau i can create very easily the following visual 

but in power bi i get as fas as the following, is it my or power bi's limitation 😄 

which looks pretty messed up

[PaulDBrown]

@Anonymous 

This is the closest I have managed...not exactly the same, but...

[parry2k]

@Anonymous exactly that's the best you can do, you cannot drive the color based on Yes/No (red/green)

[Anonymous]

@PaulDBrown  thx,

the resolution of the image is unfortunately very poor (or my eyes),  and how did you achieve it?  

[PaulDBrown]

@Anonymous 

I haven't succeeded in including the yes/no.

Here is the PBI file if you're interested:

 https://1drv.ms/u/s!AhGKDZz6e4HesheNGOZ9QElh9MJr?e=rbSviO 

[Anonymous · Accepted solution]

Thanks everyone,

i have "solved" the problem by placing multiple visuals side by side, creating the desired effect

a major problem with this approach is the amount of time one would invest if there e.g. 80 countries in the datamodel.  The question that arieses here is,  is there a way to automate plotting visuals???

[Anonymous]

Hi,

do you need something like this?

Regards

Lorenzo

[Anonymous]

yes sir!

[Anonymous]

Perfect!

You have to set off the "Concatenate labels" option in the X Axis section of the Format properties of Visualization pane.

 

Country as legend gives different colors by Country effect.

If you agree with my solution, please give me a kudo.

Regards

Lorenzo

[PaulDBrown]

@Anonymous 

Great solution you came up with! I wouldn't imagine it is that cumbersome to create a side-by side solution as you have created for a number of countries. Surely you can create a "master" chart, duplicate and use the filter pane to allot each country?

On another note, you can of course resort to creating custom visuals using R, of which I am completely ignorant though I did come across this example which does seem to point towards what you were looking for:

Table with embeded chart in Power Bi using R 

[Anonymous]

@PaulDBrown   thx.

the problem R or Python script generated plots are missing interactivity.  Meaning, the filtering, slicing etc would not work.  Correct me if i am wrong.

[PaulDBrown]

@Anonymous 

I'm afraid my knowledge of R / Python is 0, and I haven't looked into the implications regarding interactivity etc, so I can't be of much help..

This page seems to say they do, however, respond to slicers etc:

How to create custom visuals in Power Bi using R 

There is also a resource/tool which helps create custom visuals without coding, though I have never tried it out:

Charticulator 

[Anonymous]

@PaulDBrown  thx a lot, i'll definitely take a look at those two.

[Anonymous]

continuing the same thread:
why are the bar thickness different although everyting else is the same.

can anyone help me out here.

[parry2k]

@Anonymous you need to use line and clustered column chart

and put % on line values. and format pane, under shapes, change turn on Stepped

[parry2k]

@Anonymous you can achieve following

[Anonymous]

thx @parry2k ,
i forgot to mention, the color code is used for other purpose (red: no, green:yes)

[parry2k]

@Anonymous aha, afaik that is not possible currently until you find out a visual on market place that I can achieve it.