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
e_j
Frequent Visitor

Replicate Tableau Dual Axis Scatter Plot in Power Bi

Capture.JPGHi,

 

I am trying to replicate the above Tableau visual in Power Bi. The issue I am having is finding the capabilities in Power Bi to produce a dual axis as I need to plot the 'score' twice. 

 

The aim is to compare a client score (shown as the green coloured data points) to the rest of the dataset (backing data) whilst keeping the backing data anonymised.

 

So far, via using Power Bi, I have been able to plot the 'backing data' which is showing a similar distribution. However, Power Bi is not giving me the option to add the average lines neither am I able to add the 'client' specific scores. I have looked at importing dual axis visuals from the visual market available when using Power Bi Desktop however they only seem to be for bar charts.

 

Thanks in advance for any help and suggestions.

e_j_1-1623410666113.png

e_j_0-1623410650836.png

4 REPLIES 4
ryealienwebcroc
Regular Visitor

My coworker and I found another solution. 

 

1. Put the data into a line plot, where Backing Score and Client Score are both in the y-axis.

2. Go to Format Visual -> Visual -> Markers. Turn Markers on.

3. Select Series = Backing Score and you may need to turn "show marker" on for that specifically.

4. Open Shape (inside Markers) and change the size to 5 px. You should see dots connected by your line plot. Repeat for Client Score.

5. Now go up to (Format Visual -> Visual ->) Lines.

6. Select Series = Backing Score. Open Shape and change Stroke width to 0 px. Do the same for Client Score. The lines will go away, leaving just the marker dots!

asitm
Helper III
Helper III

Hi @e_j 

 

You have to use a custom visual like below fir dual axis for scatter plot.

 

Dual Axis scatter plot with PBIVizEdit.comDual Axis scatter plot with PBIVizEdit.com

Download link in this page
https://pbivizedit.com/gallery/dual_axis_scatter 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  •  anyone, irrespective of technical skills, can create their own visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.

You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

thanks,

AsitM (PBIVizEdit)

e_j
Frequent Visitor

Hi, thank you for responding to my query.

Unfortunately your suggestion didn't resolve the issue. We simply took two scatter graphs and overlayed them and used the interaction settings and slicers to create the dynamic aspect of it.

amitchandak
Super User
Super User

@e_j , In scatter visual you should able to plot the Average lines both on the x and y-axis , You should be able to add a measure as size

 

I added here - https://www.youtube.com/watch?v=CNNKQTiUemI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=27

 

or you can design one with help from charticulator

https://www.youtube.com/watch?v=QIPsv5hNbqI

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors