Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi All,
I have 4 text columns that have large descriptions , in my table visual I only want to show initially 30 characters from each cell and will have my width according to that , but if a user hovers over a cell they should see the entire text . Any ideas ?
id desc 1 desc 2 desc 3 desc 4
1 This is a long description intended to provide a detailed explanation of the first item. It includes various aspects such as background, context, and relevance, ensuring that the text is lengthy enough to approach around 300 characters in total length. This second description field for item one is deliberately verbose to mimic the kind of extended documentation often used in technical or project reports. It expands on possible use cases, limitations, and context to ensure adequate coverage of the topic. A third description column exists to provide even more contextual elaboration for item one. Here, the text is intentionally verbose, ensuring that readers get comprehensive exposure to supporting details, commentary, and extended analysis regarding the given subject. Finally, this fourth description column for the first row extends the overall richness of the dataset by giving further narrative and thoughtful elaboration. The text ensures that the entry feels fully fleshed out, reaching the length needed while staying informative.
2 The description here elaborates on the second item with extended text that offers clarification, contextualization, and supporting details. It ensures that readers fully grasp the importance and significance of this entry by providing depth and breadth. In the case of the second item, the secondary description offers expanded narrative that delves into supporting examples, explanations, and scenarios that might arise in practice. The content length helps demonstrate thoroughness and clarity in communication. In row two, the third description expands upon what has already been outlined, providing a narrative arc that ensures all aspects are addressed. This helps paint a complete picture of the item and strengthens the overall usefulness of the provided data. The secondary row in this column provides depth and detail in describing item two. Its purpose is to augment the previous columns by layering in insights, potential impacts, and supporting commentary, thereby offering completeness in descriptive style.
3 For the third item, this description dives deeply into the nuances and broader context surrounding the subject. The purpose is to deliver a comprehensive narrative that allows the reader to fully understand and evaluate the information being presented. For the third row, the description here provides additional information, ensuring that any ambiguities are clarified. The intention is to give readers access to rich and descriptive commentary that goes well beyond superficial explanations or summaries. The third row’s tertiary description takes on a storytelling approach, weaving together key aspects of the subject with related contextual information, practical examples, and explanatory commentary, thereby creating an enriched and fuller description. For the third entry, the description continues to expand on what has been introduced, serving as a final detailed commentary. It rounds out the understanding by synthesizing earlier insights, ensuring readers gain a holistic and nuanced comprehension.
4 The fourth entry is explained in detail through this description, which outlines both the surface-level elements and underlying context. By extending the text length, this ensures enough detail is provided to capture complexity while remaining readable. The fourth item's secondary description adds depth by discussing how the content connects with broader themes, frameworks, or external examples. Such elaboration ensures that this entry is perceived as robust, detailed, and grounded in a comprehensive viewpoint. In row four, this description is extended to highlight the significance and implications of the subject matter. By elaborating across multiple dimensions, this text ensures that it approaches the intended character length, while remaining coherent and detailed. This row’s fourth description provides additional insights, long explanations, and contextualization that bridges prior commentary with forward-looking observations. It remains consistent in style and length to align with the other descriptions.
5 Finally, the fifth item is accompanied by this extended description that covers multiple angles, interpretations, and applications. It provides rich insights and meaningful perspectives that make the entry substantial and valuable to the reader. For the fifth and final row, this secondary description enriches the explanation by layering in more detail, nuance, and interpretation. It illustrates how this item may be perceived in various contexts, adding depth and ensuring readability and richness. The last row in this column carries forward the tradition of expansive detail, ensuring that item five is explained with sufficient coverage. It provides clarity, examples, and context in a way that leaves little ambiguity for the intended audience. In the fifth and last row, the description here is crafted to close the set of columns with strong elaboration. It strengthens the depth of understanding by adding layered insights, comprehensive commentary, and extended perspectives for the audience.
Hi @Vivek26 ,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
For any further discussions or questions, please reach out to fabric community forum.
Thank you.
Hi @Vivek26 ,
Thanks for reaching out to the Microsoft fabric community forum and thank you @danextian for their helpful explanation, their points are accurate.
Currently, using the LEFT() function to truncate text will also shorten the tooltip, and page tooltips work at the row level rather than the cell level. Additionally, tooltips do not support scrolling, so long text may still be cut off.
Some additional points to consider: To let users view the full text, a drillthrough page is often a more reliable solution, though it requires a click instead of a hover. Also switching to a Matrix visual with word wrap enabled may help reduce the need for truncation in some cases. For detailed text review, exporting the data to Excel can provide more flexibility.
As of now, Power BI does not offer a native feature to expand cell text on hover. If this would be useful for your reports, consider submitting or upvoting it in Fabric Ideas - Microsoft Fabric Community, where customer feedback is reviewed for future updates.
Hope this helps. Please feel free to rech out for any further questions.
Thank you .
Hi @Vivek26 ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.
Hi @Vivek26
You can truncate a text string using the LEFT function, but this will also shorten the tooltip text. One workaround is to use a page tooltip to display the full text. However, keep in mind that interactions within a page tooltip aren’t currently supported. This means that if a text value in a table is long enough to require a scrollbar, it will still appear truncated and you won’t be able to scroll within the page tooltip. Also, the page tooltip is applied to the entire row and not just to a cell. Another option is to use a drillthrough page, though that won’t provide the same "hover" experience.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.