Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Edit Variables as Slicer or dropdown for the user

Hi,   I am using HANA view as a data source for my Direct Query Power BI Desktop Report. HANA View works on mandatory variables that need to be passed such as 'UNIT' in which the data will be calc...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    You have created a parameter named Unit, and define some values for it , right? If so, change {Cube.ApplyParameter,"UNIT",{'"&Unit&"'}} to the following:

    {Cube.ApplyParameter,"UNIT",{""&Unit&""}}

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi I am also facing the same issue and How to create the growth calculations in power bi Because I am using SAP HANA datasource direct query...?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

     

    I think you can use quick measure or create measure to create measures in Direct query mode as well.

     

     

    Regards

    Power BI User