Bookmarks based on matrix data availability through bookmark navigation

[Nareshreddy]

I have multiple bookmarks 

 Sales ,Cogs, profit along their related data in matrix visual 

Based on the data availability 

I have to show like if sales is there then I have to show sales tab and matrix visual 

vice versa.

Please help me anyone 

[v-venuppu]

Hi @Nareshreddy ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu · Accepted solution]

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.

[Nareshreddy]

 
From Above tabs needs to be dynamic  when data is available

[Nareshreddy]

Hi Leroy Lu,
Actually I am having Multiple Bookmarks each bookmark is having one table along their related data.
I will give one example to explain what I want clearly
If I am patient I am having some basic details on overview page & Navigating to detail page  through drill through.
Now in details page I have certain tabs or bookmarks like Diagnosis,Allergies,Observations,Procedure,careplan
 Each one  I have created oen bookmark now What I want means If  patient is having Diagnosis, observation, careplan means then I need to show those tabs dynamically and the same way I need to show that person related details in table visual based on the above tab selection If all details are available then I have to show all tabs along their  related data.

[Anonymous]

Hi, @Nareshreddy 
 

Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

If your bookmark is a visual object, you can try creating a measure to modify the colour of the visual object, thereby achieving visibility toggling.

My sample data is as follows:

Create the following measure:

Measure1 = IF(CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[table]="Cogs"&&NOT(ISBLANK('Table'[values]))))> 0,"Black", "White")

Modify the visual colour:

The result is as follows:

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nareshreddy]

For Column header text colour is not having Fx otherwise i coulg have thatone