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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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