Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a field parameter - pretty straight forward like below.
This is on page A.
On page B, I'd like to use the same parameter, except for line "Top Countries" -
I want this to be replaced by ("Top 10 Countries SEARCH", NAMEOF('Top X'[SEARCH_TOP10_COUNTRY]), 1),
So final would look like this: If Page A, then show Version A with top countries, if page B then show verion B with Search top countries
Is there a way to do that? Or do I need to create a new parameter for each page?
So
param_gross = {
("Overall", "None", 0),
("Top 10 Countries", NAMEOF('Top X'[GROSSB_TOP10_COUNTRY]), 1),
("Company Region", NAMEOF('dim_company'[COMPANY_REGION]), 2),
("Company Country", NAMEOF('dim_company'[COMPANY_COUNTRY]), 3),
("Company Origin", NAMEOF('dim_company'[COMPANY_ORIGIN]), 4)
}
Solved! Go to Solution.
Hi @maziiw
Power BI can’t tell what page you're on, so you’ll need to set things up yourself. Add all the fields to your field parameter, then use page-level filters to control which ones show up on each page.
Hi @maziiw ,
Thank you for reaching out to the Microsoft Fabric Community. Also thank you @danextian , @Akash_Varuna and @Shravan133 for your insights.
In Power BI, field parameters provide a powerful way for users to switch between fields dynamically in visuals. It’s important to note that these parameters are intentionally static, once a field parameter is set up, its list of fields remains unchanged regardless of the report page being viewed.
If you want to display “Top 10 Countries” on Page A and “Top 10 Countries SEARCH” on Page B using the same parameter, Power BI doesn’t currently allow field parameters to adapt based on page context. Their structure is fixed and does not update automatically depending on the report page.
To achieve page-specific variations, you have strong alternatives. You can include both field versions in a single parameter and leverage filters or slicers on each page to control visibility. Alternatively, you can create separate parameters for each page and use them independently. While field parameters offer flexibility in user selection, their contents are fixed, so page-specific behavior requires targeted solutions like filters or dedicated parameters.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
Hi @maziiw
Power BI can’t tell what page you're on, so you’ll need to set things up yourself. Add all the fields to your field parameter, then use page-level filters to control which ones show up on each page.
Hi @maziiw Field parameters are static and cannot dynamically change based on the page. To achieve this, create two separate parameters: one for Page A (with "Top 10 Countries") and one for Page B (with "Top 10 Countries SEARCH"). Use a slicer or button to detect the current page and switch parameters dynamically using a DAX measure. Alternatively, assign each parameter directly to visuals on their respective pages.
you can't directly change the definition of the parameter by page.
param_gross = { ("Overall", "None", 0), ("Top 10 Countries", NAMEOF('Top X'[GROSSB_TOP10_COUNTRY]), 1), ("Top 10 Countries SEARCH", NAMEOF('Top X'[SEARCH_TOP10_COUNTRY]), 5), ("Company Region", NAMEOF('dim_company'[COMPANY_REGION]), 2), ("Company Country", NAMEOF('dim_company'[COMPANY_COUNTRY]), 3), ("Company Origin", NAMEOF('dim_company'[COMPANY_ORIGIN]), 4) }
On Page A, filter out "Top 10 Countries SEARCH" in your slicer or set a default.
On Page B, filter out "Top 10 Countries" and default to the SEARCH version.
Or, if you don’t want users to choose at all, use DAX to dynamically control the field in your measure or visual:
SelectedField = SWITCH( TRUE(), SELECTEDVALUE('Page Filter'[Page]) = "A" && SELECTEDVALUE('param_gross'[param_gross_order]) = 1, SELECTEDVALUE('Top X'[GROSSB_TOP10_COUNTRY]), SELECTEDVALUE('Page Filter'[Page]) = "B" && SELECTEDVALUE('param_gross'[param_gross_order]) = 5, SELECTEDVALUE('Top X'[SEARCH_TOP10_COUNTRY]), -- Add other mappings as needed BLANK() )
And use this SelectedField in your visuals instead of directly using the parameter.
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |