Forum Discussion
Maieev
Resolver I
Resolver IDynamic columns picking in matrix live connection
Hi community,
I have reports with live connection containing big matrix tables with many columns. I wonder if there is a way to build a slicer or something with column names for viewers to be able to pick whatever columns they want to see in their table? I cannot edit or unpivot table or create parameters with live connection (correct me if I'm wrong) so is there any other option for me?
Thanks!
2 Replies
- Idrissshatila
Super User
Hello Maieev ,
the concept you're explaining can usually be done through field parameters but as in microsoft documentations:
- You can't create parameters in live connection data sources without a local model. However, 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).
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
MaieevAlright, saying I would switch to local model how can I do it with field parameters?
