The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've used field parameters in several visuals (e.g., bar charts and matrices) in my Power BI report. These work as expected in Power BI Desktop: when I select a category using a slicer, the visuals dynamically display the corresponding subcategories. When I deselect the category, the visuals revert back to showing the category level.
However, after publishing the report to the Power BI Service, this behavior changes. When I deselect the category in the slicer, the visuals do not revert to the category level. Instead, they continue to display all subcategories.
Has anyone else encountered this issue? Is this a known limitation or a bug in the Power BI Service? Any suggestions or workarounds would be appreciated.
Solved! Go to Solution.
Okay, I guess I figured it out myself.
First, to provide a bit of context about what I have and what I want: I have a population table of British Columbia's Health Authorities, and a silcer for that:
I wanted to when selecting one of these, the pie chart automatically switch to show the HA's sub-regions (HSDAs), like this (e.g, choosing Vancouver Coastal):
Before the Field Parameter update in Power BI Service, I could do this by a dynamic field parameter. But as the July 2025 Update explains, now it preserves the hierarchy so by unselecting the slicer you would get all the HSDAs in the pie chart, not the HAs.
So, what I did:
I created a table like this:
and created a measure to calculate the population:
the measure's main feature is to generate BLANK() when the HSDA is not selected and BLANK for the location scopes that are not within the selected HA.
Let me know what you think.
Hi @homa_data
This is a known issue/limitation with field parameters in the Power BI Service: after deselecting a slicer option, visuals sometimes don’t revert to the higher-level field and keep showing all subcategories.
It works correctly in Power BI Desktop, but the service behavior differs due to how the field parameter table filters are applied in the service.
explicitly select the category field in the slicer (instead of deselecting), or create a default parameter value measure to handle blank selections.
Microsoft is aware of similar inconsistencies; if critical, you can raise a support ticket or check the Power BI Community forums for updates.
Okay, I guess I figured it out myself.
First, to provide a bit of context about what I have and what I want: I have a population table of British Columbia's Health Authorities, and a silcer for that:
I wanted to when selecting one of these, the pie chart automatically switch to show the HA's sub-regions (HSDAs), like this (e.g, choosing Vancouver Coastal):
Before the Field Parameter update in Power BI Service, I could do this by a dynamic field parameter. But as the July 2025 Update explains, now it preserves the hierarchy so by unselecting the slicer you would get all the HSDAs in the pie chart, not the HAs.
So, what I did:
I created a table like this:
and created a measure to calculate the population:
the measure's main feature is to generate BLANK() when the HSDA is not selected and BLANK for the location scopes that are not within the selected HA.
Let me know what you think.
Hi @homa_data,
Great to hear that it's working as expected on your end!. I would suggest accepting your approach as the solution so that it can benefit others as well. It would be really helpful for others in the community who might be facing similar issues and can address them quickly.
Thanks & Regards,
Prasanna Kumar
Hi @homa_data
Create a Single Select parameter
SelectedCategory = IF( ISFILTERED('Category'[Category]), SELECTEDVALUE('Category'[Category]), "Default Category" )
" "
so it’s invisible.
Regards,
Ritesh
Thanks very much, this is actually helpful.. but isn't any way to work around this, basically keeping the behavior same as how it is in the desktop version (as of now)?
Please read the blog entry. They changed the behavior, for better or for worse.
Power BI July 2025 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI