Tooltip

[Anonymous]

Hi everyone.

I'm trying to show on a scatter chart the SAP Rating and Sales by UPRN, but because it's summarizing I'm getting some numbers for SAP Rating where I don't have data. 

The example below, on the data source, it's supposed to be blank or zero as there's no value for this UPRN, but I'm getting this 13.

Also, each blue dot is one address, but the tooltip os only shows the first address. How can I show the correct address for each dot?

How could I solve this?

Many thanks!

[AllisonKennedy]

@Anonymous 

The SAP Rating is doing a SUM - click the down arrow next to SUM of SAP rating in the Visualizations pane and change that to 'don't summarize'.

Technically each dot shows a single combo of SAP rating and UPRN, so if there is more than one address per UPRN, there could be multiple addresses and the Tooltip only displays the 'first'. You can change the name of this by double clicking on the 'First Address' in the Visualizations pane and renaming to 'Address' or you could use a report page tooltip. 

I just gave you a lot of info and not sure what your Power BI level is so just let me know if you need more details, links or screenshots. 

[Anonymous]

Thanks, Allison.

When I change to "Don't summarize", I get the error message below.

Unfortunately, the UPRN is unique, so there isn't more than one address per UPRN. And regardless of the dot I click/hover over it always shows the same address.

I've tried to create a tooltip report page, but it shows all the addresses from the filtered local authority, and not only from the dot I'm hovering over. 

Thank you.

[Anonymous]

Hi @Anonymous ,

Please try to move the field UPRN to the Legend option just as below screenshot and check whether it can get what you want.

Best Regards

[Anonymous · Accepted solution]

Thanks! It did not work either. 
I just create page navigation, so the user could see the values by UPRN. 

[Anonymous]

Hi @Anonymous ,

Thanks for your sharing. Could you please mark your post as Answered if there is nothing else need help about this thread? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards