Showing only first 100 characters in matrix view, but when hovering should display full text

[Anonymous]

In my matrix I have a column that has fields that have long text. I want to only show the first 100 characters, and the rest should be displayed only when hovering over that column; or when drilling down is this possible? 

I really wanted it to work, I looked all over these forums, it only shows way of shortening the text by using LEFT, but I want to have the full text available when drilled down or when hovered; however, the first 100 characters should be displayed normally in the table 

[aaronv]

I have a similar problem.  My matrix visual is only showing 100 characters per field, but I would like it to show the entire text from the source.. is this possible or is a limitation of the visual?

[MahyarTF · Accepted solution]

Hi,

In My point of view, as you want to show the first 100 char on the main page, you need to create a new column to substring those (use the left Dax function) and the tooltip is coming from the shown columns.

For showing the complete description in Tooltip, my suggestion is to create the Tooltip page or custom page and put the Card visual, that is included in the main column and show this page as a tooltip page on the main page.(hide the Tooltip page)

[AUDISU]

Hi @Anonymous ,

Please reffer following ling. 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

Thanks