Bookmarks based on matrix data availability through bookmark navigation

Hi Nareshreddy ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Anonymous for the prompt response.

Here are some steps to solve the issue:

1. Create Visibility Measures

You need a measure for each tab. Here's an example for the Diagnosis tab:

ShowDiagnosis =
IF(
CALCULATE(COUNTROWS('DiagnosisTable')) > 0,
1,
0
)

Repeat for ShowAllergies, ShowObservations, etc.

2. Add Buttons for Each Tab

• Insert a button for each tab (e.g., Diagnosis, Allergies...)
• Set each button's visibility using conditional formatting:
• In the button style → visibility → fx, bind it to the corresponding measure.

Use the formula:

IF([ShowDiagnosis] = 1, TRUE(), FALSE())

3. Setup Bookmarks

Create separate bookmarks for each tab (e.g., Diagnosis_Bookmark, Allergies_Bookmark).

Each bookmark shows the relevant matrix visual and hides others.

• Group visuals by tab in the Selection Pane for easier bookmark management.

4. Add Action to Buttons

Assign each button an Action → Bookmark → corresponding bookmark.

5. Final Step (Optional)

Use a slicer or drill-through field to filter the current patient so all measures evaluate per that context.

By following the above steps the result will be as follows:

When the user navigates to the patient detail page:

• Only the tabs with relevant data appear

• Clicking a tab shows the related visual

• Fully dynamic based on the data for that patient

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 Thank you.