topic Dynamic table based on slicer in Developer https://community.fabric.microsoft.com/t5/Developer/Dynamic-table-based-on-slicer/m-p/3429893#M44441 <P>So, I have a table like this:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD><STRONG>Player Number</STRONG></TD><TD><STRONG>Shots</STRONG></TD><TD><STRONG>Shots on target</STRONG></TD><TD><STRONG>Pressures</STRONG></TD><TD><STRONG>Recoveries</STRONG></TD><TD><STRONG>Key Passes</STRONG></TD><TD><STRONG>Assists</STRONG></TD></TR><TR><TD>Player 1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to create groups:<BR /><BR />Group 1 = Shots and Shots on target<BR />Group 2 = Pressures and Recoveries<BR />Group 3 = Key Passes and Assists<BR /><BR />Use groups in slicer, and based on the slicer change table data.<BR /><BR />When selected Group 1 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Shots</TD><TD>Shots on target</TD></TR><TR><TD>Player 1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When selected Group 2 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Pressures</TD><TD>Recoveries</TD></TR><TR><TD>Player 1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When selected Group 3 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Key Passes</TD><TD>Assists</TD></TR><TR><TD>Player 1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Player 2</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can anyone help me ?</P> Thu, 14 Sep 2023 04:02:20 GMT AGaribay7 2023-09-14T04:02:20Z Dynamic table based on slicer https://community.fabric.microsoft.com/t5/Developer/Dynamic-table-based-on-slicer/m-p/3429893#M44441 <P>So, I have a table like this:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD><STRONG>Player Number</STRONG></TD><TD><STRONG>Shots</STRONG></TD><TD><STRONG>Shots on target</STRONG></TD><TD><STRONG>Pressures</STRONG></TD><TD><STRONG>Recoveries</STRONG></TD><TD><STRONG>Key Passes</STRONG></TD><TD><STRONG>Assists</STRONG></TD></TR><TR><TD>Player 1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to create groups:<BR /><BR />Group 1 = Shots and Shots on target<BR />Group 2 = Pressures and Recoveries<BR />Group 3 = Key Passes and Assists<BR /><BR />Use groups in slicer, and based on the slicer change table data.<BR /><BR />When selected Group 1 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Shots</TD><TD>Shots on target</TD></TR><TR><TD>Player 1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When selected Group 2 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Pressures</TD><TD>Recoveries</TD></TR><TR><TD>Player 1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>Player 2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When selected Group 3 in slicer:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Player Number</TD><TD>Key Passes</TD><TD>Assists</TD></TR><TR><TD>Player 1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Player 2</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Player 3</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can anyone help me ?</P> Thu, 14 Sep 2023 04:02:20 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-table-based-on-slicer/m-p/3429893#M44441 AGaribay7 2023-09-14T04:02:20Z Re: Dynamic table based on slicer https://community.fabric.microsoft.com/t5/Developer/Dynamic-table-based-on-slicer/m-p/3434909#M44489 <P><BR />You cannot create a calculated column or calculated table from a measure/slicer/filter.<BR /><BR /></P> Sun, 17 Sep 2023 23:25:19 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-table-based-on-slicer/m-p/3434909#M44489 lbendlin 2023-09-17T23:25:19Z