Hide bookmarks based on filter selection

[PwrBiNwB]

Hi there,

I'm quite new in Power Bi.

I have a page with 12 buttons at the top (let's call them "Data levels"). Each button, when clicked, show different levels of data.

Users can filter the data by using the filters on the right hand side. Then they can use the buttons to display the relevant data. Works fine.

My problem is that for some filtered values, data is available for only 1, 3 or 7 levels of data. But user don't know which one.

They have to click on each of the 12 buttons. Is there a way to display ONLY the buttons for which we have data available as shown below?

  Thank you for your support.

PwrBiNwB

[Ritaf1983]

Hi @PwrBiNwB 

Unfortunately, there is no direct way for a button to dynamically influence the filters on the side of the page.

However, it’s possible to work around this issue using a slicer or a measure-based solution. For example, if there is a measure that shows blank values for certain filter selections, you could use a slicer instead. This slicer can be filtered by the measure to only display non-blank values (e.g., using a condition like "is not blank").

To provide more specific guidance, i would need to review the file structure and data model. If you're able to share your file, you can upload a version of it to a public cloud without sensitive data and share a link.

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