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.
Good day to all,
Seeking help with a creative solution here. Web searches and specific searches here are not giving useful results.
We have a drill through page (from a table visual) with product specifications. (Meaning there are a lot of SELECTEDVALUE functions in the measures.)
The team has asked that I create a single text box visual that contains multiple "Notes" fields (preferably separated by a Header/Title) that will scroll vertically when there are sufficient notes to extend outside the borders of the text box.
While I have taken the interim route of creating bookmarks (10 of them!) with action buttons to display each field separately in the same location, this is not ideal.
Is there a way to combine multiple text fields into a single text box? Is there a way to separate/name the sections?
What am I missing?
Please note that I am trying to avoid the horizontal scrolling of a typical table visual here.
Thanks very much for your time and creativity!
Trent
Update: Since it is not a massive dataset in terms of rows, I decided to duplicate the table, reduce it down to the necessary columns, then unpivot the Notes fields.
This allowed me to use a standard table to populate the fields with just two columns (eliminating the side scroll thanks to text wrapping) and when many fields are populated or have lengthy values, it is a vertical scroll.
Adds a bit of overall size but I think balances out with the 10 action buttons and 10 text boxes being replaced by a single table.
Have a great day!
Trent
@TrentS , You can enable Q&A, and then you should be able to use measure inside a text box, if that can help
Thanks for the suggestion, I will look into it.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |