Forum Discussion

matbauwin's avatar
matbauwin
Regular Visitor
2 years ago

Wrong list appears in tooltips

Hi everyone,

I created a bar chart showing how many organisations achieve what type of impact (social and/or environmental).

I created a tooltip to display the names of the organisations concerned. For that, I first created a measure: a list of organisations able to display up to 100 names.

The problem is that the tooltip does not display the names of the organisations concerned by each type of impact, but the names of all organisations corresponding to the filters applied in the page. See the image below where 4 organisation names appear for the category "préservation de la biodiversité" where the bar indicated only 1 organisation.

How can I display only the names of the organisations corresponding to the number of organisations in the chart?

Thanks!

 

 

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi matbauwin ,

     

    How is the measure that you created to return the result for this tooltip?

  • dk_dk's avatar
    dk_dk
    Icon for Super User rankSuper User
    2 years ago

    Hi matbauwin 

    Are you able to share how your data model looks like?

    I suspect that the table which includes the impact types in the bar chart does not filter the table that contains the organisations (the table your measure is referencing). Depending on your data model you might be able to just set the cross-filter direction between the two tables to "both". Alternatively you might need to adjust your measure so it filters the list with LOOKUPVALUE or some other way.

    If you can share more about how your data looks like I may be able to help further!

    Best regards,

    Daniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi matbauwin ,

     

    Whether the advice given by dk_dk  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

     

    Best Regards,

    Neeko Tang

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