Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kshe
Frequent Visitor

Dynamic hierarchy using fields parameter works on desktop but not on cloud service

Hi,

 

We are using the dynamic hierarchy built from field parameter to select different level for Matrix and drill down.

It's working perfectly before but suddenly not working on service today. Any idea? It's still working perfectly on desktop.

kshe_0-1752288829539.png

On service, when I click and unclick 'Level 2', it won't go back to default 'Level 1', it stays on 'Level 2'.

Also when I select both 'Level 2' and 'Level 3', I cannot drill down to 'Level 3' on the matrix. It shows 'Level 2' only.

 

Any change from Power BI service side today?

 

Thanks.
K

 

 

21 REPLIES 21
JTBrownPGIM
New Member

We too are noticing an issue on our side exactly the same.  Users are not happy.  Behavior seems to have changed within the past week or so, in the Power BI service (Fabric) itself.

Steps to reproduce:
1. Create a field parameter

2. Assign hierarchy related fields from one dim in order.

3. Assign hierarchy related fields from another dim with fewer fields in order.

4. Create a calculated column to group the fields into groups relative to their hierarchy.

5. Place the field parameter on the ROWS well of a matrix, and place some measure on the matrix to roll up.

6. Create a hierarchy slicer based on the field parameter with the group column first, then the field parameter column as second.  Make the slicer multi-select.

7.  Select the first grouping with more columns.  The matrix rolls up to the top level.

8. De-select the first grouping with more columns and select the second grouping with fewer columns.  The matrix rolls up to the top level.

9. De-select the second grouping and select the first, the matrix correctly rolls back up to the top level.

10. Publish the report to Fabric workspace and repeat steps 7-9.  In the Fabric service online, the drill-level for the matrix will not correctly re-set when transitioning back from group2 to group1 - it always shows the lowest level of whatever was selected with Group 2.

 

Really annoying.

There's a long explanation in the Power BI blog for the July 2025 version. Not that it makes it any better but at least they explain why they did it.

 

Power BI July 2025 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

V-yubandi-msft
Community Support
Community Support

Hi @kshe  ,
Is everything clear now, or do you need any more information or clarification.


Thank you.

V-yubandi-msft
Community Support
Community Support

Hi @kshe ,

Could you please update us on the status of your issue? Has it been resolved, or have you reached out to Microsoft support for help? Let us know if you still need any assistance.

V-yubandi-msft
Community Support
Community Support

Hello @kshe ,

May I check if you've raised a support ticket for this issue, or is it working fine on your end now? Based on community responses, it seems to be working intermittently some users are experiencing issues while others are not. Just wanted to confirm your current status so we can assist further if needed.

 

Thanks&regards,

Yugandhar.

V-yubandi-msft
Community Support
Community Support

Hi @kshe ,

Thank you for engaging with the Microsoft Fabric Community. I tested the report with a dynamic hierarchy using field parameters and found that the issue only occurs in Power BI Service. In Power BI Desktop, everything works as expected slicer selections and drill downs reset properly to Level 1 when higher levels are unchecked.

In the Service, after selecting Level 2, unchecking it does not bring back Level 1, and the drill down feature gets stuck, not allowing navigation past intermediate levels. This appears to be a recent change in how the Matrix visual manages field parameter context online.

FYI:

Vyubandimsft_0-1752475640482.png

 

I haven’t seen any official updates from Microsoft, but the problem is consistent across workspaces. Thanks to @rohit1991 , for helping confirm this. For now, we recommend users work in Desktop for full hierarchy and drill features until this is resolved in the Service.

 

Regards,

Yugandhar.

lbendlin
Super User
Super User

Can you pinpoint when it stopped working?

 

lbendlin_0-1752408824462.png

 

Just wondering, that page with all of the Powerbi Service versions looks like it is in the powerbi service? How does one find that page? 

That page is a SharePoint list we maintain internally with Power Automate to keep track, precisely because Microsoft are very secretive about service version changes.

Hi @Dominoes2 ,

To find your current Power BI Service version, open Power BI in your browser, click the question mark icon at the top right, and choose About Power BI  from the dropdown. A pop up will show information like the Service version, Client version, data location, and last update time.

 

 

Vyubandimsft_1-1752574361650.png

 

This feature gives you the latest build details, but Microsoft does not provide a complete public version history. Detailed version logs with release dates are usually from internal dashboards, which are not available to the public.

 

If you want to make it even more polished for a community post or documentation, you could add a quick note about alternative resources like:

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
Use semantic model version history (preview) - Power BI | Microsoft Learn

 

Hope this helps...

kshe
Frequent Visitor

working all the way till 7/11/25 PST.

They pushed a new service version yesterday - can you try again?

Not working for me either.  We have dynamic field parameters in matrices throughout embedded applications and they are not working consistently.

Would appreciate any workarounds anyone has.

I have tried just now and the issue still persists. Do you know of any work arounds for the interim or when mirosoft is going to have a fix out? 

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

kshe
Frequent Visitor

Thanks. I noticed today the drill down is working. However the default view back to the highest Level is still not working as before.

Hi @kshe , @Dominoes2  & @slilley ,

Can you raise a support ticket with Microsoft for further investigation. MS team will be able to look into the issue more thoroughly and help resolve it.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

Thanks &regards,

Yugandhar.

Working better for me this morning - maybe they rolled back - anyone else?
<crossing fingers>

Seems to work on my side too,  it doesn't work a few hours ago but works now.

I have talked to microsoft support who did confirm that a fix for this issue was released. I have gone through and tested some of the reports I have and found that it was resolved. However in some cases, depending what state the user left the report in, they would need unselect and reslect the chosen row parameters.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.