Forum Discussion
Slicer that filter Columns SSAS
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
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.
1 Reply
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.