Forum Discussion
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 organizations in a data set with varying engagement levels (high/med/low) that span different regions.
In terms of data points, I have:
- org name
- engagement
- region.
I should add that I need to also ideally convey density graphically.. this is less about useable "dashboarding" per se and more to convey overall message of where we stand from an engagement perspective.
Originally, was hoping to use a scatter plot to have regions on the x axis and engagement on y axis to then plot Org name. However, I learned that non-numeric data is not useable..
Do you have any recs on what visualization to use if not a scatter plot? Any advice would be much appreciated!
7 Replies
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?
