Forum Discussion

jvirgi's avatar
jvirgi
Helper III
3 years ago
Solved

Field Parameter Error with Key Influencer Visual [bug?]

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?

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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..

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

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

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    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.

     

     

  • Starfox64's avatar
    Starfox64
    Frequent Visitor
    3 years ago

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