Forum Discussion

Shkelzen_zariqi's avatar
Shkelzen_zariqi
Frequent Visitor
3 years ago
Solved

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 wan...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.