Field Parameter Error with Key Influencer Visual [bug?]

[jvirgi]

I was looking to make a Key Influencer Visual using a Field Parameter as the 'Analyze' attribute.  However, it gives the following error:

'The analysis is performed at the record level of the 'Parameter' table.  A field in 'Explain by' is not on the 'Parameter' table or a table from the same data source and related to it by a many to one relationship.  

I think this must be a bug?  Any ideas?

[Anonymous]

There is a workaround. In PQ make a new table by referencing your fact table and unpivot on all fields apart from your ID field. 

So 

.. becomes ..

Make a single selection slicer on the Attribute and use the Value field as the field to Analyse in the visual.

The result ..

.. or ..

...etc..

[Person2025]

This works nicely for me. Great workaround, thank you~!

[Starfox64]

Is there a way to request this as a feature? It would be helpful on reports with multiple metrics. 

[parry2k · Accepted solution]

@jvirgi if you check the limitation on field parameter, it doesn't support AI and Q&A visual and key influences is a AI visual. Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.