Create Button to send a specific field-value to a sheet

Hi jerryr125 

To achieve this behavior in Power BI—where a user clicks a button to navigate to a details page filtered by the top "kpi-store-name"—you can use Bookmarks with Page Navigation and field parameters or sync slicers to simulate a dynamic drill-through experience. However, since DAX measures like your kpi-store-name are not directly selectable in visuals or slicers, you'll need to work around this limitation. Here’s a practical approach:

First, create a separate page (e.g., "Order Details") that shows the full list of orders from 'tbl_abc'. Then, create a drill-through field based on [StoreDesc] (if not already created), and place it in the drill-through section of the details page. On your main report page, instead of using a DAX measure in a button, add a transparent button over a card visual that displays the kpi-store-name measure. Users won’t click the measure directly, but rather the button over it. To make the interaction dynamic, use a SELECTEDVALUE pattern: create a slicer or visual filtered to the top store, based on your logic, and allow users to click into it, which then passes context to the drill-through.

Since your measure returns a single store with the highest open orders, you can create a calculated table or disconnected table that lists all stores, then create a selection-based navigation approach: when a store is selected, show the button, and clicking it navigates to the detail page. Alternatively, you can consider using Power BI's new dynamic page navigation features, where a button with a page navigation action can navigate to a drill-through page based on the context set by a slicer or card visual.

Unfortunately, there’s no native way to directly click a measure and pass that value dynamically to another page via a button, but combining drill-through filters, transparent buttons, and visual interactions gives a smooth user experience.