Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

tooltips acting differently between SQL table and SSAS

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 displ...
General Comment
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      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