Forum Discussion
Creating a bookmark with long text strings
- 1 month ago
Hi Scott,
Totally doable — here is the setup that works cleanly:
1. Create your Notes table Two columns: Note Index (integer) and Text Note (text). You can use a simple M query or a calculated table — no DAX measures needed.
2. Add a Table visual
- Drop in both columns: Note Index and Text Note
- Format > Values > Word Wrap → On
- Drag the Text Note column edge to the width you want — this is the only way to control column width in a standard table. You cannot type in an exact pixel value, but the dragged width saves and persists reliably
3. Show/hide with bookmarks
- Create two rectangle shape buttons labelled "Notes"
- Set up two bookmarks:
- Bookmark 1: table visible, Button A visible, Button B hidden
- Bookmark 2: table hidden, Button B visible, Button A hidden
- Link each button to its bookmark via Format > Action > Type: Bookmark
Clicking the button toggles the table in and out as a side panel. The two-bookmark swap is the standard pattern for this.
The output is neat and readable — it is just manual rather than formula-driven, but it works well once set up.
Power BI matrix doesn’t let you fix column width by a number, and a bookmark just keeps whatever layout you set by hand, so for long notes I use a text box with wrap and a fixed size, or turn Auto-size column width off on the matrix, drag the note column to a good width, then save that view as a bookmark.