tooltips acting differently between SQL table and SSAS

[Anonymous]

We have some fields with long text (such as product name, manufacturer name, etc.) which is not good to display the whole data on the chart. I now display the item code, and use the tooltips to display the proper name. Well, this works if I connect to SQL table. If I use the SSAS cube as my data source, the tooltips will give me two options - count or count distinct. Is there any way to solve this issue - tooptips acting differently with different types of data connection!

Thanks,

Wenchi Wang

[v-jiascu-msft]

Hi @Anonymous,

1. Which visualization do you use?

2. What's the connection type? Import or Direct Query?

I reproduce it by change the "show value as". You can check it out. 

Best Regards!

Dale

[Anonymous · Accepted solution]

I am using combo visualization with ssas live connction. As you can see below, the tooltips showed count of manufacturer_des instead of the manufacturer_des even though i did select no calculation.

 

[v-jiascu-msft]

Hi @Anonymous,

I have found a workaround. According to my test, your SSAS model is tabular. You can add a measure like this to act as a tooltip.

ColorTips =
CONCATENATEX ( VALUES ( 'Product'[Color] ), 'Product'[Color], "," )

You can replace the blue part with your columns that you want to show up in the tooltips.

Best Regards!

Dale