topic Re: Bookmarks based on matrix data availability through bookmark navigation in Developer

Bookmarks based on matrix data availability through bookmark navigation

Nareshreddy — Thu, 06 Mar 2025 07:55:23 GMT

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

Re: Bookmarks based on matrix data availability through bookmark navigation

Anonymous — Fri, 07 Mar 2025 03:04:49 GMT

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.

Re: Bookmarks based on matrix data availability through bookmark navigation

Nareshreddy — Fri, 07 Mar 2025 11:08:19 GMT

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.

Re: Bookmarks based on matrix data availability through bookmark navigation

Nareshreddy — Mon, 10 Mar 2025 07:11:20 GMT

From Above tabs needs to be dynamic when data is available

Re: Bookmarks based on matrix data availability through bookmark navigation

Nareshreddy — Mon, 10 Mar 2025 07:12:55 GMT

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

Re: Bookmarks based on matrix data availability through bookmark navigation

v-venuppu — Thu, 24 Apr 2025 13:26:05 GMT

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.

Re: Bookmarks based on matrix data availability through bookmark navigation

v-venuppu — Mon, 28 Apr 2025 10:33:18 GMT

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.