cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zyc
Helper I
Helper I

Adding a custom reference point on scatter plot

I am working on a scatter chart to display Speed (X-axis) vs Consumption (Y-axis) of different vehicle designs. The goal of the report is to examine that for the same design, is the particular vehicle specified by the user (that is not available in the current data set) more or less efficient than that of others in the data set.

I would like to know if it is possible for the user to input the specifications for the user specific vehicle's X-axis and Y-axis within the report itself so that the user can compare it visually.

As seen in the image below, say the user has input the specifications for the specific vehicle when it is laden (in red) and when it is ballast (in green).

 

the desired outcome (if it is even possible)the desired outcome (if it is even possible)

 

@amitchandak sir, wondering if you could assist!

1 ACCEPTED SOLUTION
zyc
Helper I
Helper I

I have been trying this out for the past week, the only method that worked (for me at least), was via PowerApps. 

Thank you everyone for contributing to the discussion.

View solution in original post

5 REPLIES 5
zyc
Helper I
Helper I

I have been trying this out for the past week, the only method that worked (for me at least), was via PowerApps. 

Thank you everyone for contributing to the discussion.

amitchandak
Super User
Super User

@zyc , As X and Y, are measure. Do want to say specific values to be highlighted. We can use conditional formatting, but I doubt that will work with a legend.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Thanks for the suggestion. Let's say the legend isn't there, how should I go ahead using conditional formatting to achieve the desired result?

v-lionel-msft
Community Support
Community Support

Hi @zyc ,

 

"I would like to know if it is possible for the user to input the specifications for the user specific vehicle's X-axis and Y-axis within the report itself so that the user can compare it visually."

You can add the X-axis and Y-axis fields to the slicer, and modify the X-axis and Y-axis values through the slicer.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-lionel-msft ,

Thank you for taking time to reply. I have tried your suggestion and unfortunately it did not achieve what I have intended. 

What I am trying to achieve is to have the user insert a customised data point can be plotted on the scatter chart - that is not already on the existing data set, as opposed to what you are suggesting that highlights an existing data point on the scatter chart.

 

Say for example when I filter for a particular make of the vehicle, I obtain 3 data points, e.g. (10.0. 12.3), (11.9, 14.2). (14.3, 17.9). I would like the user to be able to enter a customised data point, say (13.0, 15.0), to see how it compared to the existing data points. 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!