Slicer that filter Columns SSAS

[Shkelzen_zariqi]

Hello,

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. 

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 

[v-jianboli-msft · Accepted solution]

Hi @Shkelzen_zariqi ,

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 DirectQuery for Power BI datasets and AS (preview).

Besides, you can transform your data and create a matrix visual like this:

Then you can slicer the column:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.