Forum Discussion
plotting, visuals,
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???
Community ChampionAnonymous
I haven't succeeded in including the yes/no.
Here is the PBI file if you're interested:
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???
- 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
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:
Hi,
do you need something like this?
Regards
Lorenzo
yes sir!
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