https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179486#M13159 <P>Thanks!</P> Thu, 07 May 2026 18:45:37 GMT dcohenvogel 2026-05-07T18:45:37Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179468#M13157 <P>I have a parameter that allows me to toggle among different dimensions of a product. For example, I can select either Product Type or Product Storage Requirements as options. I want the user to be able to choose those different views of the products, with rows representing geographic divisions, and the columns that show up will have the values associated with each parameter selection (type = produce, beverages, canned goods, etc.; storage = frozen, dry, etc.) grouped by fiscal year - in other words, those values will be grouped under fiscal years, and it will show (e.g.) current fiscal year product types next to prior fiscal year product types when selecting product type. However, when I put the fiscal year field above the parameter in the column section of my matrix, only the fiscal year appears on the page. If I switch them and put fiscal year beneath the product type, only product type appears on the page and sums across both fiscal years. Any insights? Thanks.</P> Thu, 07 May 2026 18:01:00 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179468#M13157 dcohenvogel 2026-05-07T18:01:00Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179483#M13158 <P>use the fork arrow to expand the hierarchy.&nbsp; If you have both row and column hierarchies you first need to set to "drill on columns"</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1778178896813.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1347777i9F0235B01F58CC53/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1778178896813.png" alt="lbendlin_0-1778178896813.png" /></span></P> <P>&nbsp;</P> Thu, 07 May 2026 18:35:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179483#M13158 lbendlin 2026-05-07T18:35:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179486#M13159 <P>Thanks!</P> Thu, 07 May 2026 18:45:37 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/matrix-with-parameter-in-columns/m-p/5179486#M13159 dcohenvogel 2026-05-07T18:45:37Z