Forum Discussion

abd8's avatar
abd8
Regular Visitor
9 months ago
Solved

Matrix with Dynamic Rows Based on Slicer

Hi!   I have a hiearchy slicer and matrix. When I select nothing on the filter, I want the matrix to show Level 1. When I select a Level 1 item on the slicer, I want the matrix to dynamically updat...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    8 months ago

    Hi abd8,

    Apologies for the delay in getting back to you.

    Power BI does not currently support using a hierarchy slicer to automatically move between levels in a matrix. A slicer always acts as a filter, so when a user selects something like Europe, Power BI filters the entire model to Europe it does not switch the matrix to the next level (e.g., France, England) or hide the current level. While this type of “level navigation” feels natural from a user perspective, the product simply isn’t designed to work that way today.

    The practical alternatives are to rely on the built-in matrix drill-down, create separate views using bookmarks, or redesign the report layout to guide users through levels in a more step-by-step manner. These options allow you to provide a similar navigation experience, even though native slicer-driven level switching isn’t available yet.

    Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
9 months ago

Hi abd8,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to xifeng_L, Ashish_Mathur, danextian, for those inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
9 months ago

Hi abd8,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    8 months ago

    Hi abd8,

    Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

    Thank you.

    • abd8's avatar
      abd8
      Regular Visitor
      8 months ago

      Thanks for the reply! I think I was unclear in my original question. I don't want it to just drill down. I want the table to dynamically update to show one level below what I select in the slicer as my top level.

      So if I select Europe in the Slicer, Europe would no longer show on the table. It would dynamically update to the next level down and show France and England.

       

      • v-kpoloju-msft's avatar
        v-kpoloju-msft
        Community Support
        8 months ago

        Hi abd8,

        Apologies for the delay in getting back to you.

        Power BI does not currently support using a hierarchy slicer to automatically move between levels in a matrix. A slicer always acts as a filter, so when a user selects something like Europe, Power BI filters the entire model to Europe it does not switch the matrix to the next level (e.g., France, England) or hide the current level. While this type of “level navigation” feels natural from a user perspective, the product simply isn’t designed to work that way today.

        The practical alternatives are to rely on the built-in matrix drill-down, create separate views using bookmarks, or redesign the report layout to guide users through levels in a more step-by-step manner. These options allow you to provide a similar navigation experience, even though native slicer-driven level switching isn’t available yet.

        Thank you for using the Microsoft Fabric Community Forum.