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 

[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.

[v-linyulu-msft]

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