Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |