Forum Discussion

tbridge263's avatar
tbridge263
New Member
1 year ago

Excel Pivot Table won't display an analysis services cube's properties in tooltip

This may not be the right forum but I don't know any that could answer this.  We have Excel users that like to hover over pivot tables and see any properties that the source may have. The source is an analysis services multi dimensional cube.  The pivot table options have the feature selected.  The tooltip just stopped displaying the properties.  It does display the data for the context of what is in the pivot table.  So if I add a property to a pivot table, the tooltip will display that property.  But, it didn't previously need the propoerty to be shown in the pivot table to be able to be seen in the tooltip.  We have a lot of properties users don't want to clutter up their pivot table with that they just want to see in the tooltip.

Need Help

3 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    1 year ago

    HI tbridge263 ,

     

    Somebody here might just know the answer but this is the Power BI forum so that is unlikely.  The proper forum for this question is here:  Excel | Microsoft Community Hub

     

    Can you please either mark this as answered so others do not keep checking it out or delete it from the Power BI Forum

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi tbridge263 

     

    Have you solved your problem?
    Could you mark the helpful answer as the solution to close the thread?

    Thank you very much for your kind cooperation!

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Poojara_D12's avatar
    Poojara_D12
    Icon for Super User rankSuper User
    1 year ago

    Hi tbridge263 

    The issue with missing tooltips in Excel PivotTables connected to Analysis Services might be due to settings, updates, or cube changes.

    Troubleshooting Steps:

    1. Check PivotTable Settings:

      • Ensure Show properties in tooltips is enabled in PivotTable Options > Display.

    2. Cube Design:

      • Verify that the expected properties are still defined and accessible in the cube.

    3. Excel Updates:

      • Test on a different Excel version or check for updates that might have affected tooltip behavior.

    4. Recreate PivotTable:

      • Create a new PivotTable with the same connection to see if the issue persists.

    5. Connection Validation:

      • Check the cube connection under Data > Connections to ensure it’s properly configured.

    6. Workaround:

      • Add properties as hidden fields in the PivotTable for tooltip access without clutter.

    If the issue persists, escalate to Microsoft support or test in another environment.

     

    Did I answer your question? Mark my post as a solution, this will help others!
    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS