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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
andrew_wellman
Regular Visitor

Edit Interactions not working

On my report, I have a slicer that determines which metric is displayed on the line graph. All other visuals on the page are set for "No Interaction" using the edit interactions function. Upon report reload, the visuals that should not be interacting, are being filtered by the slicer. changing the selection in the slicer will enable all visuals to display appropriately. After which, you are able to change your slicer to the preffered option, and everythings works accordingly. 

Img 1: report launched

andrew_wellman_0-1735662136781.png

Img 2: Toggled 2nd option in slicer

andrew_wellman_1-1735662155838.png

Img 3: All options selected in slicer

andrew_wellman_3-1735662187667.png

Img 4: Limited to 1 selection in slicer

andrew_wellman_4-1735662211831.png

Img 5: Interaction setup (there are many shapes placed as backgroup components and multiple card visuals, hence the multiple interaction options for a metric)

andrew_wellman_5-1735662278857.png

 

 

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

Hi @andrew_wellman ,

It sounds like you're encountering an issue with how the slicer interacts with the parameter in your Power BI report. Here are some of my personal thoughts:

 

1. Parameters in Power BI can sometimes behave differently compared to direct measures, especially when it comes to interactions and filtering. Since your primary metric is stored in a "Metric" parameter that switches between measures, this could be causing the unexpected behavior upon report reload.

You can look at this document: 

Solved: Dynamic Parameter is not working with the slicer w... - Microsoft Fabric Community

 

2. Even though you've set the visuals to "No Interaction," the parameter might still be influencing the visuals indirectly. This could be due to how parameters are processed during the report's initial load.

If you want to learn more about it, I think you can look at this document:

Solved: Default value for parameter, connected with slicer... - Microsoft Fabric Community

 

 

Best Regards

Yilong Zhou

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

2 REPLIES 2
v-yilong-msft
Community Support
Community Support

Hi @andrew_wellman ,

It sounds like you're encountering an issue with how the slicer interacts with the parameter in your Power BI report. Here are some of my personal thoughts:

 

1. Parameters in Power BI can sometimes behave differently compared to direct measures, especially when it comes to interactions and filtering. Since your primary metric is stored in a "Metric" parameter that switches between measures, this could be causing the unexpected behavior upon report reload.

You can look at this document: 

Solved: Dynamic Parameter is not working with the slicer w... - Microsoft Fabric Community

 

2. Even though you've set the visuals to "No Interaction," the parameter might still be influencing the visuals indirectly. This could be due to how parameters are processed during the report's initial load.

If you want to learn more about it, I think you can look at this document:

Solved: Default value for parameter, connected with slicer... - Microsoft Fabric Community

 

 

Best Regards

Yilong Zhou

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

 

 

andrew_wellman
Regular Visitor

I should also add that this is a single data source in play - no relationships. 

The primary values are stored in a "Metric" parameter that switches between measures. The Compare to and Variation values are a multi-card that is also based off of the selected "Metric", but is a combination of several measures (compare value, difference, % difference)

It is interesting that the multi-card metrics are not impacted by the slicer (as expected) but the primary metric is. 

Could this be because I am using a parameter to switch between the measures and should rather be using the measure itself?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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