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

[jerryr125]

Hi - 

I am looking to do the following:

* Create a button that will send the user to another sheet with details. 

the measure is called "kpi-store-name"

Note: the measure for the "kpi-store-name" is 

var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))

return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])

* This measure works and returns the store name with the greatest number of OpenOrders

I would like for the user to click the button to see the specific orders

Any thoughts ?

[v-pgoloju · Accepted solution]

Hi @jerryr125,

Thanks for giving detailed information on the requirement.

I have created a calculated table using DAX as shown below:

TopOpenStores =
VAR a =
SUMMARIZE(
FILTER('tbl_abc', 'tbl_abc'[Open Orders] = "Y"),
[StoreDesc],
"ct", COUNTROWS('tbl_abc')
)
VAR maxCt = MAXX(a, [ct])
RETURN
FILTER(a, [ct] = maxCt)
On the Details Page, I have placed two columns for visualization.
On the Main Page, a button has been added and configured to navigate to the Details Page.

I have reproduced the scenario as per the requirement and attached the .pbix file for your reference.

If the issue still persists, please feel free to reach out — we’re here to help.

Thank you & Regards,
Prasanna Kumar

[jerryr125]

Perfect !!! Thank you very much !

[Poojara_D12]

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.

[v-pgoloju]

Hi @jerryr125,

Thank you for reaching out to the Microsoft Fabric Forum Community.

First, insert a button by going to the Insert tab and selecting Button. You can choose a blank button or one with text, such as "View Orders". Place the button on your report canvas. Then, in the Visualizations pane, enable the Action toggle and set the Type to Page navigation, selecting the target page where the order details will be shown.

To pass the selected store name (the one with the highest number of open orders) to the detail page, you can use Bookmarks and Selections to maintain context between pages. You might also use Sync Slicers to filter the data on the detail page according to the selected store.

On the detail page, create a dynamic filter by creating a measure that retrieves the selected store name:

SelectedStoreName = SELECTEDVALUE('tbl_abc'[StoreDesc])
Then, create another measure to filter the orders for the selected store:

FilteredOrders =
CALCULATE(
COUNTROWS('tbl_abc'),
'tbl_abc'[StoreDesc] = [SelectedStoreName]
)

This ensures that the orders page will display only the orders associated with the selected store.

Optionally, you can customize the button's text by using a measure that dynamically changes based on the selected store name. For example, use the following .

ButtonText = "View Orders for " & [kpi-store-name]

This will update the button text to reflect the store that the user can click to view the associated orders.

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

Thank you & Regards,
Prasanna kumar

[jerryr125]

Hi @v-pgoloju 

Thank you for the response. I believe this is getting close.

1. I created the measure - no issues:

SelectedStoreName = SELECTEDVALUE('tbl_abc'[StoreDesc])

2. This measure is giving me an error message

FilteredOrders =
CALCULATE(
COUNTROWS('tbl_abc'),
'tbl_abc'[StoreDesc] = [SelectedStoreName]
)

"A function PLACEHOLDER has been used in a True/False expression that is used as a table filter expression. This is not allowed."

3. On the main page - the button I created to navigation to the Orders Page, I selected for the action type "Page Navigation" and then the Destination "Orders" page, do I need to set anything else ?

4. On the orders page, do I need to set anything in the drill-through section or filters section?

Any assistance is appreciated.  Thanks - Jerry

[v-pgoloju]

Hi @jerryr125,

Thank you for reaching out to the Microsoft Fabric Forum Community.

to filter the order records based on this selected store, define another measure that counts the rows in the 'tbl_abc' table where the store matches the selected one. You can’t use this directly inside CALCULATE like that. Instead, wrap it with a FILTER function.

FilteredOrders =
CALCULATE(
COUNTROWS('tbl_abc'),
FILTER('tbl_abc', 'tbl_abc'[StoreDesc] = [SelectedStoreName])
)

Do Not use Drill-through if you're using Page Navigation + Sync slicers, then drill-through is not needed.

Sync slicers: If you’re using a slicer to pick the store on the main page, go to the slicer settings and sync it with the Orders page:

Select the slicer > go to View > Sync slicers

Check the checkbox for the Orders page.

Page Filters / Visual-level filters:

You don’t need to manually add filters if you're using the synced slicer or the SelectedStoreName measure in visual filters.

Best regards,
Prasanna Kumar

[jerryr125]

Hi - I think we are getting very close.

All of the measure work.

kpi-store-name = 

var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))

return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])

FilteredOrders =
CALCULATE(
COUNTROWS('tbl_abc'),
FILTER('tbl_abc', 'tbl_abc'[StoreDesc] = [SelectedStoreName])
)

SelectedStoreName = SELECTEDVALUE('tbl_abc'[StoreDesc])

I have a button that goes from the home to the OpenOrders page.

What is the action do I need to set for the OpenOrders Page ? 

Do I need to set a Drillthrough or Filter on the OpenOrders Page?

THere is no slicer/sync slicer for these measures.

Thoughts ? Jerry

[v-pgoloju]

Hi @jerryr125,

Could you please share a few screenshots of your setup—particularly the button settings, the OpenOrders page, and any relevant filters or visuals? Kindly blur or mask any secured or sensitive data fields. This will help me better understand your scenario and provide a more accurate resolution. Additionally, a clear explanation of your requirements, along with any expected output, would be greatly appreciated to ensure an accurate and efficient response.

Thanks & Regards,

Prasanna kumar

[jerryr125]

Hi - @v-pgoloju 

Thank you again for your help.

Ok, here is what I am trying to do.

Data table:

tbl_abc

StoreDesc	OrderID	Open Orders
StoreA	12	Y
StoreA	34	Y
StoreA	56	N
StoreB	78	Y
StoreB	90	Y
StoreC	AB	Y
StoreD	CD	Y
StoreE	EF	Y
StoreE	GH	N

measure:

kpi-store-name = 

var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))

return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])

kpi-store-name results in StoreA, StoreB since both stores have two open orders (the "N" are not included

PAGE: HOME

measure:

kpi-display-card = 

tbl_abc[kpi-store-name] & "has the most open orders"

Displays:

StoreA, StoreB has the most open orders

The kpi-display card measure appears in a card visualization on the home page.

I added an invisible box on the homepage. When the end-user clicks on the card I would like them to go to a page "store-open-orders".  The "store-open-orders" page displays a table visualization.  The table visualization has the following:

PAGE: store-open-orders

table visualization:

StoreDesc	OrderID	Open Orders
StoreA	12	Y
StoreA	34	Y
StoreB	78	Y
StoreB	90	Y

So I basically would like to connect the visible button from the home page to the store-open-orders page.  The store-open-orders page would filter on the values in the measure "kpi-store-name".'

I think we are close - just need to connect and filter - Jerry

[jerryr125]

Yes i agree - but the value in the meaure appears in a card with text and other values...

[lbendlin]

include the appropriate drillthrough fields so you can recreate (or reuse) the measure on the target page.

[lbendlin]

instead, use the "Drillthrough"  feature and teach your users how to use it.