Hi @pam__081 ,
Currently, Power BI's native functionality for conditional drill-through is primarily designed around the use of buttons, as detailed in the official documentation. This involves setting up a button that dynamically changes its drill-through destination based on certain conditions defined by DAX measures.
Regarding the use of right-click for a similar purpose, Power BI does not offer built-in support for customizing the right-click context menu to achieve conditional drill-through actions directly. The right-click menu in Power BI is generally used for actions such as drilling down on visuals that support hierarchy, accessing data point details, or exporting data, rather than for conditional navigation.
You can submit an idea for it at https://ideas.powerbi.com/ideas/ and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
