https://community.fabric.microsoft.com/t5/Developer/Slicer-that-filter-Columns-SSAS/m-p/2970869#M40324 <P>Hello,</P><P>I need to create slicer to filter columns not rows in power bi I can do that using parameters fields but my database is SSAS and im not allowed to create parameters in power bi.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Shkelzen_zariqi_0-1671110678411.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/841598iB1D36DADC3ADD174/image-size/medium?v=v2&amp;px=400" role="button" title="Shkelzen_zariqi_0-1671110678411.png" alt="Shkelzen_zariqi_0-1671110678411.png" /></span></P><P>I want to create a slicer like this in photo when i select a column ore more in slicer that column apear in table and columns that are not selected i dont want to see them , but in ssas I'm not allowed&nbsp;</P> Thu, 15 Dec 2022 13:26:23 GMT Shkelzen_zariqi 2022-12-15T13:26:23Z https://community.fabric.microsoft.com/t5/Developer/Slicer-that-filter-Columns-SSAS/m-p/2970869#M40324 <P>Hello,</P><P>I need to create slicer to filter columns not rows in power bi I can do that using parameters fields but my database is SSAS and im not allowed to create parameters in power bi.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Shkelzen_zariqi_0-1671110678411.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/841598iB1D36DADC3ADD174/image-size/medium?v=v2&amp;px=400" role="button" title="Shkelzen_zariqi_0-1671110678411.png" alt="Shkelzen_zariqi_0-1671110678411.png" /></span></P><P>I want to create a slicer like this in photo when i select a column ore more in slicer that column apear in table and columns that are not selected i dont want to see them , but in ssas I'm not allowed&nbsp;</P> Thu, 15 Dec 2022 13:26:23 GMT https://community.fabric.microsoft.com/t5/Developer/Slicer-that-filter-Columns-SSAS/m-p/2970869#M40324 Shkelzen_zariqi 2022-12-15T13:26:23Z https://community.fabric.microsoft.com/t5/Developer/Slicer-that-filter-Columns-SSAS/m-p/2972082#M40336 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/480968">@Shkelzen_zariqi</a>&nbsp;,</P> <P>&nbsp;</P> <P><SPAN>If you use DirectQuery for Power BI datasets and AS (preview), you can add a local model to create field parameters. For more information about using DirectQuery for live connections, see&nbsp;</SPAN><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services#using-directquery-for-live-connections" data-linktype="relative-path" target="_blank">DirectQuery for Power BI datasets and AS (preview)</A><SPAN>.</SPAN></P> <P><SPAN>Besides, you can transform your data and create a matrix visual like this:</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vjianbolimsft_0-1671154190357.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/841927iB6A0080FA56E3D7A/image-size/medium?v=v2&amp;px=400" role="button" title="vjianbolimsft_0-1671154190357.png" alt="vjianbolimsft_0-1671154190357.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vjianbolimsft_1-1671154211380.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/841928i326357D4705038DB/image-size/medium?v=v2&amp;px=400" role="button" title="vjianbolimsft_1-1671154211380.png" alt="vjianbolimsft_1-1671154211380.png" /></span></P> <P>Then you can slicer the column:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vjianbolimsft_2-1671154250776.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/841930i152DA4C7A1657992/image-size/medium?v=v2&amp;px=400" role="button" title="vjianbolimsft_2-1671154250776.png" alt="vjianbolimsft_2-1671154250776.png" /></span></P> <P style="background: white; margin: 7.5pt 0in 0in 0in;"><SPAN>Best Regards,</SPAN></P> <P style="background: white; margin: 7.5pt 0in 0in 0in;"><SPAN>Jianbo Li</SPAN></P> <P style="background: white; margin: 7.5pt 0in 0in 0in;"><SPAN>If this post&nbsp;<STRONG><I>helps</I></STRONG>, then please consider&nbsp;<STRONG><I>Accept it as the solution</I></STRONG>&nbsp;to help the other members find it more quickly.</SPAN></P> Fri, 16 Dec 2022 01:31:26 GMT https://community.fabric.microsoft.com/t5/Developer/Slicer-that-filter-Columns-SSAS/m-p/2972082#M40336 v-jianboli-msft 2022-12-16T01:31:26Z