How can we improve Power BI?

Allow calculated measures in web designer

At the moment if you're using the web based designer, you're unable to create custom measures. This currently means you have to go back to the source data to add in all possible measures

189 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stephen Moir shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    16 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        I'm surprised this feature isn't available already! Makes it painful when you aren't the publisher of the report but still responsible for editing it.

      • Anonymous commented  ·   ·  Flag as inappropriate

        BLOT Important feature. Please consider releasing it soon

        What if I am connecting to a CRM platform like Salesforce to gather the dataset? I may not have the access/ability to edit the source data even!

      • Steve Moir commented  ·   ·  Flag as inappropriate

        I find this to be a problem when using Stream Analytics as a source. You need to include all calculated fields in the query which limits what you can actually do.

      • Vino commented  ·   ·  Flag as inappropriate

        Need some calculation on PowerBI using Jira connector
        I need to calculation the time of project finished
        can't connect to jira on PowerBI dekstop
        please update so Power BI online can do that

      • Josefina commented  ·   ·  Flag as inappropriate

        We have calculated measures in a Cube but we can´t use them in Power BI, is there a way?

      • Anonymous commented  ·   ·  Flag as inappropriate

        Would really like to be able to create measures in the Web Power BI, and not need to install the Desktop.

      • Ran commented  ·   ·  Flag as inappropriate

        Adding the ability to edit/see or create a calculated field in the Web App would be great.
        I'm connecting directly to Project Online via odata feed, some field are already calculated and i want to see how they were calculated but unable to. I do have a desktop version but it doesn't help me in that regard.

      • Michael Billing commented  ·   ·  Flag as inappropriate

        This is a no brainer, since you would be able to use PBI Web to create real/quality reports on any data source. Thus using files in a cloud drive as datasource is way more userfriendly and flexible than the gateway system. And this feature would leverage this use case.

      • Kat Innes commented  ·   ·  Flag as inappropriate

        I’m regularly asked for reports to be adjusted with different percentages. Every time a new percentage calculation is requested from a different business sector I have to update/redesign a desktop report and republish to the web or make changes to SQL data warehouse. It would be much more efficient for the business if department users with web designer access apply a calculated measure for themselves; particularly as many of the queries are not of long term interest.

      • Jeffrey Brown commented  ·   ·  Flag as inappropriate

        The ability to live more in the browser and less in desktop will allow a much better enterprise distribution. We're creating models in ITS that we pass out to business units, and I don't want to have to re-create the dataset each time - the business units should have the power to change the model in their domain. This would provide that capability without having to force them into Power BI Desktop

      • Minsuk Kang commented  ·   ·  Flag as inappropriate

        Please add this feature. We are importing data through REST API so web designer is only available. We cannot calculate success rate.

      • Tom Marek commented  ·   ·  Flag as inappropriate

        This is especially an issue with Direct Connect sources like Azure SQL Database and Azure Data Warehouse since you cannot aggregate aq percentage from a fact table today.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.