topic Filter each column seperately based on slicer value in Power BI DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3684681#M143118 <P>Hi All,</P><P>Below is my data. I need to filter the values based on the slicer selection&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>0</TD><TD>4</TD><TD>4</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>6</TD><TD>6</TD></TR><TR><TD>-99999</TD><TD>7</TD><TD>0</TD></TR><TR><TD>2</TD><TD>8</TD><TD>-99999</TD></TR><TR><TD>4</TD><TD>9</TD><TD>9</TD></TR><TR><TD>7</TD><TD>5</TD><TD>-99999</TD></TR><TR><TD>7</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD><TD>1</TD></TR><TR><TD>-99999</TD><TD>0</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>1</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>8</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>8</TD><TD>1</TD><TD>1</TD></TR><TR><TD>9</TD><TD>-99999</TD><TD>-99999</TD></TR></TBODY></TABLE><P><img /></P><P>When I select any value in the slicer I need only those values in the columns I dont need any other values and slicer needs to work independent filtering of columns. For example If I select '-99999' I need below output.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Output</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>&nbsp;</TD><TD>-99999</TD></TR></TBODY></TABLE><P>When I select 0 in the slicer then the output I need like below.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>0</TD></TR></TBODY></TABLE><P>Can anybody let me know how I can achive this by using DAX. If you have any idea to achieve please help on this.<BR />Thank for your time.</P> Wed, 07 Feb 2024 05:36:13 GMT SriBhaskar 2024-02-07T05:36:13Z Filter each column seperately based on slicer value in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3684681#M143118 <P>Hi All,</P><P>Below is my data. I need to filter the values based on the slicer selection&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>0</TD><TD>4</TD><TD>4</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>6</TD><TD>6</TD></TR><TR><TD>-99999</TD><TD>7</TD><TD>0</TD></TR><TR><TD>2</TD><TD>8</TD><TD>-99999</TD></TR><TR><TD>4</TD><TD>9</TD><TD>9</TD></TR><TR><TD>7</TD><TD>5</TD><TD>-99999</TD></TR><TR><TD>7</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD><TD>1</TD></TR><TR><TD>-99999</TD><TD>0</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>1</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>8</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>8</TD><TD>1</TD><TD>1</TD></TR><TR><TD>9</TD><TD>-99999</TD><TD>-99999</TD></TR></TBODY></TABLE><P><img /></P><P>When I select any value in the slicer I need only those values in the columns I dont need any other values and slicer needs to work independent filtering of columns. For example If I select '-99999' I need below output.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Output</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>-99999</TD><TD>&nbsp;</TD><TD>-99999</TD></TR></TBODY></TABLE><P>When I select 0 in the slicer then the output I need like below.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>0</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>0</TD></TR></TBODY></TABLE><P>Can anybody let me know how I can achive this by using DAX. If you have any idea to achieve please help on this.<BR />Thank for your time.</P> Wed, 07 Feb 2024 05:36:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3684681#M143118 SriBhaskar 2024-02-07T05:36:13Z Re: Filter each column seperately based on slicer value in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3684917#M143128 <P>please use SWITCH in DAX</P> Wed, 07 Feb 2024 07:17:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3684917#M143128 Nitish2024 2024-02-07T07:17:53Z Re: Filter each column seperately based on slicer value in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3688761#M143314 <P>Can you please explain in detail or give example when I tried it gives result like below. I need the above output.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>exp</TD><TD>2017</TD><TD>2021</TD></TR><TR><TD>-99999</TD><TD>6</TD><TD>6</TD></TR><TR><TD>-99999</TD><TD>7</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>0</TD><TD>0</TD></TR><TR><TD>-99999</TD><TD>-99999</TD><TD>1</TD></TR><TR><TD>2</TD><TD>8</TD><TD>-99999</TD></TR><TR><TD>7</TD><TD>5</TD><TD>-99999</TD></TR><TR><TD>8</TD><TD>-99999</TD><TD>-99999</TD></TR><TR><TD>9</TD><TD>-99999</TD><TD>-99999</TD></TR></TBODY></TABLE> Thu, 08 Feb 2024 15:24:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3688761#M143314 SriBhaskar 2024-02-08T15:24:05Z Re: Filter each column seperately based on slicer value in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3693472#M143585 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="442641" data-lia-user-login="SriBhaskar" class="lia-mention lia-mention-user">SriBhaskar</a></FONT>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>The result you want would destroy the relationship between the rows of the original table, so it is not possible.&nbsp;</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jayleny</P> <P>&nbsp;</P> <P>If this post&nbsp;<STRONG><EM>helps</EM></STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Mon, 12 Feb 2024 07:22:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-each-column-seperately-based-on-slicer-value-in-Power-BI/m-p/3693472#M143585 Anonymous 2024-02-12T07:22:36Z