Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

How to apply dax as measure on specific visual using javascriptapi?

Hi Guys,

How to apply dax as measure on specific visual using javascriptapi?
I know that there is execute queries rest api to execute dax. 

But how to apply dax on already existing visual?

Best,
Jacek

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jaryszek ,
    Thank you for posting in the Microsoft Fabric Community.

     

    Currently, the Power BI JavaScript API does not support dynamically creating or applying new DAX measures to existing visuals within an embedded report. However, you can assign pre-defined measures to visuals using the API's setDataFields() method. For executing custom DAX queries, consider using the Execute Queries REST API, which allows running DAX queries against a dataset and retrieving results.

    Please refer to the following documentation for more information:

    Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    For dynamic measure selection, it's advisable to predefine multiple measures in your dataset and enable users to choose among them as needed.

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thankyou

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jaryszek ,
    Thank you for posting in the Microsoft Fabric Community.

     

    Currently, the Power BI JavaScript API does not support dynamically creating or applying new DAX measures to existing visuals within an embedded report. However, you can assign pre-defined measures to visuals using the API's setDataFields() method. For executing custom DAX queries, consider using the Execute Queries REST API, which allows running DAX queries against a dataset and retrieving results.

    Please refer to the following documentation for more information:

    Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    For dynamic measure selection, it's advisable to predefine multiple measures in your dataset and enable users to choose among them as needed.

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thankyou