Forum Discussion
Edit Interactions not working
- Anonymous1 year ago
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.
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?