Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cageybee
Regular Visitor

How can I achieve this in Power BI?

Hi guys,

 

I am a Tableau developer and I am trying to learn Power BI. I need to buid an app in Powr BI that looks like this:

 

Capture.PNG

 

The app has to have a filter where I can either pick a single consultant or all of consultants. So, the circles would either show a team average or the values for a particular consultant.

 

A sample of data is below:

 

Capture 2.PNG

3 REPLIES 3
v-huizhn-msft
Microsoft Employee
Microsoft Employee

Hi @cageybee,

There is no same visual in Power BI. After research, I find a similar custom visual: Dot Plot by MAQ Software. Then you can create per visual for Ambition, Morale, Attrition, Performance and Contribution to Daughterty.  I post an example for creating a visual for Morale using your sample data. Select the data as X-axis, the average of Morale as value.

1.PNG

Then you create a slicer including consultants field, when you select one consultant in slicer, it will make an impact on the visual.

2.PNG
Best Regards,
Angelia

v-huizhn-msft,

 

Thank you for looking into this for me. However, this doesn't really look like what I need. I experimented with that viz package and it doesn't really do what I need it to do. First, I need to make the bubbles bigger than the max size of the bubbles that they have and then, I need to put a label inside of the bubble.

 

Also, I need to incorporate a logic that colors the bubble based on the criteria:

 

For Attrition only the following logic applies:

 

 

IF  (6 - ROUND(AVG([Attrition]), 1)) >= [Upper Bound] THEN

    "Excellent"

ELSEIF (6 - ROUND(AVG([Attrition]), 1)) < [Upper Bound] AND (6 - ROUND(AVG([Attrition]), 1)) >= [Lower Bound] THEN

    "Caution"

ELSEIF (6 - ROUND(AVG([Attrition]), 1)) < [Lower Bound] THEN

    "Concern"

END

 

For all others, the following logic applies (Replace [Measure] with either [Ambition], [Morale], [Performance], [Contribution to Client], or [Contribution to Daugherty]):

 

IF  ROUND(AVG([Measure]), 1) >= [Upper Bound] THEN

    "Excellent"

ELSEIF ROUND(AVG([Measure]), 1) < [Upper Bound] AND ROUND(AVG([Measure]), 1) >= [Lower Bound] THEN

    "Caution"

ELSEIF ROUND(AVG([Measure]), 1) < [Lower Bound] THEN

    "Concern"

END

Note: [Lower Bound] = 3; [Upper Bound] = 4.

 

Hi @cageybee,

Yes, got it. But Power BI features can't achieve your requirement until now. Thanks for understanding.

Best Regards,
Angelia

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.