https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Create-matrix-with-values-based-on-dropdown-list/m-p/2699527#M4890 <P>You can use Field Parameters for that.</P> <P>&nbsp;</P> <P>A much better way would be to enable "Personalize visuals" and to train your users in that feature.</P> Mon, 15 Aug 2022 01:37:43 GMT lbendlin 2022-08-15T01:37:43Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Create-matrix-with-values-based-on-dropdown-list/m-p/2698450#M4884 <P>Hello Experts,</P><P>I have created a matrix with multiple columns and measures in values. This means, I have multiple sub columns in every parent column of the matrix. Eg: Column 1 has Sub column A, B, C,D. Similarly Column 2 has A,B,C,D and so on where A and B are Columns from some table and C, D are measures created using formulas.</P><P>&nbsp;</P><P>Can I have these subcolumns selected using a drop down?</P><P>So that my matrix has only Column 1,2,3,4..... and values I can select from the dropdown which has option to select from A,B,C,D ?</P><P>&nbsp;</P><P>Thanks in advance.</P> Sat, 13 Aug 2022 08:02:02 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Create-matrix-with-values-based-on-dropdown-list/m-p/2698450#M4884 Anonymous 2022-08-13T08:02:02Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Create-matrix-with-values-based-on-dropdown-list/m-p/2699527#M4890 <P>You can use Field Parameters for that.</P> <P>&nbsp;</P> <P>A much better way would be to enable "Personalize visuals" and to train your users in that feature.</P> Mon, 15 Aug 2022 01:37:43 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Create-matrix-with-values-based-on-dropdown-list/m-p/2699527#M4890 lbendlin 2022-08-15T01:37:43Z