Forum Discussion
Bookmarks based on matrix data availability through bookmark navigation
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
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.
6 Replies
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.
For Column header text colour is not having Fx otherwise i coulg have thatone
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.
From Above tabs needs to be dynamic when data is availableHi 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. 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.
