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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sagarsahoo_123
Helper IV
Helper IV

Error in Scatter plot while bringing two sets of Data in X-axis while Y-Axis is having one data set

Hello Team,

It would be great if somebody can guide me on the Scatter Plot requirement.

In Scatter plot visualisation i want to show Active Time and Total time based on slicer selection for same set of users.

Here in X-axis i want to bring both Active time and Total time, but it is throwing some error. But if i will drag one data set at a time, it is working fine.

Is there any way how can i bring both the value in X-axis and based on slicer selection it will display the value accordingly and also in the below of Scatter plot, the matrix table should represent the value of above scatter plot.

sagarsahoo_123_0-1666157962917.png

In this above right top, the slicer is there. I want to bring the plot and below table dynamically chnaged based on the Slicer selection. If you look at the right side details of Scatter plot, it is showing me data when i have one selection in X-axis. If i will bring two values in X-axis the error is coming like below.

sagarsahoo_123_1-1666158158926.png

Can anyone help me on this!

 

Regards,

Sagar

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @sagarsahoo_123 ,

 

To get started you first need to enable the Field parameters preview feature.

  1. In Power BI Desktop, go to File > Options and settings > Options > Preview features.

  2. Select the Field parameters checkbox

vjianbolimsft_1-1666257738045.png

Best Regards,

Jianbo Li

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

View solution in original post

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

Hi @sagarsahoo_123 ,

 

To get started you first need to enable the Field parameters preview feature.

  1. In Power BI Desktop, go to File > Options and settings > Options > Preview features.

  2. Select the Field parameters checkbox

vjianbolimsft_1-1666257738045.png

Best Regards,

Jianbo Li

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

v-jianboli-msft
Community Support
Community Support

Hi @sagarsahoo_123 ,

 

Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

You can use field parameters to replace X-axis data

For more details, please refer to:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

 

Best Regards,

Jianbo Li

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

Hello,

I followed your suggestion but could not able to find the Field option in New parameter of my Power BI. Am i missing something here. Please check the image below and suggest me. There is no drop down option in New Parameter as i saw in your video. If i click into it, it is showing me like...

sagarsahoo_123_0-1666251927821.png

sagarsahoo_123_1-1666252021985.png

Regards,

Sagar

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.