Forum Discussion

jsubash's avatar
jsubash
New Member
4 years ago

Non numerical visual representation

Hi all! Relatively new Power BI user here with a specific case I'm trying to solve and at a dead end. Would love this community's feedback if possible!   In short, I need to visually represent orga...
Need Help
rsbin's avatar
rsbin
Community Champion
4 years ago

jsubash,

Perhaps try it this way:

Region on x-axis

Organization on y-axis

Turn engagement level into a number i.e 3/2/1, 15/10/5

This should enable you to use your scatter plot with the size or color of your marker representing engagement.

Hope this works for you,

Regards,

jsubash's avatar
jsubash
New Member
4 years ago

Thank you so much for all your input RSBIN.. truly. 

 

I should add the intention for management is bit more visual comms than dashboard use-ability (to reply to your earlier comment).

 

With that mind, I have created new columns and converted both region (1-6) and engagement score (1-6) with numerical placeholders. I have org name still. I think I can use a bubble chart to show quantities that fall into each quadrant (for eg. 1,2 which is asia, engaged with #no of orgs) . However, I'm not getting the fields right. Any guidance on that per chance?

  • rsbin's avatar
    rsbin
    Community Champion
    4 years ago

    jsubash,

    Unfortunately, I have rarely used scatter plots or bubble charts, so don't think I can be of much assistance here.  However, Google and Youtube can be very informative.  I normally search "Power BI & name of visual" and I get a myriad of stuff to research.

    Good Luck and Kind Regards,