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

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.

     

     

3 Replies

  • 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