Forum Discussion

richard_wylde's avatar
richard_wylde
Icon for Helper IV rankHelper IV
6 years ago

parameter controlled by slicer

Hello, In Power Query I have a query which is successfully sourced from the following, where Parameter1 is currently set to '[Sales]'   = Sql.Database("SERVERNAME", "DBNAME", [Query="SELECT  [Cl...
Need Help
nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

richard_wylde 

 

You cannot change the EditQuery parameters from the report.  You could bring sales and premium into Power BI and write a DAX measure to switch the column based on slicer selection.

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

  • richard_wylde's avatar
    richard_wylde
    Icon for Helper IV rankHelper IV
    6 years ago

    Thanks for letting me know, I shall suggest it as a new feature

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      richard_wylde that is always good, post ideas on idea forum but recommended to check if there is an existing idea and vote for that, more votes, more attention to the idea.

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      • richard_wylde's avatar
        richard_wylde
        Icon for Helper IV rankHelper IV
        6 years ago

        Thanks parry2k , do you know if there is another way I could chop up the Select statement ?