The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have requirement to generate a power BI report which is having live data connection as source. I have added a table visual in my report, which has multiple columns. One of these columns is 'Next Steps'. This column is a multiline text column which has many lines of data. Because of which the row height in the table visual is very large and so the UI is getting disturbed. As I am using live data connection, I am unable to make use of calculated columns. So using below DAX formula, I tried to truncate the lines of data to max of 100 characters and then rest of the data is showing as ellipses.
But I want to display the rest of the truncated text when hovered or clicked on the ellipses. Can anyone suggest a better way to do this. Only way for me is to use DAX as of now.
Emp ID | Emp Name | Employee location | Next Steps | Assigned to |
12345 | Thanmayee | Hyderabad | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 1 |
23456 | Satvik | Chennai | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 2 |
34567 | Moksha | Banglore | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 3 |
45678 | Jagruthi | Banglore | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 4 |
56789 | Mohan | Delhi | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 5 |
67890 | Samyuktha | Hyderabad | Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text Long text | Manager 6 |
I think you'd need to create two measures in this case - one for the normal text and one for the truncated. You would use the normal one in a new tooltip page, and then the truncated one would be in your main table.
Thanks for the response.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |