Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
DataGuy2016
Advocate IV
Advocate IV

How to edit a measure in PBI Web?

We have dashboards published into an O365 shared workspace and need to be able to edit the measures. 

 

Where is the formula bar?

 

It seems crazy that one cannot view existing measures or create new ones.

 

This means that the Master Version remains on the PBIX desktop and changes effected on PBI Web will be overwritten when new measures are added.

 

Are we missing something here please?

1 ACCEPTED SOLUTION
henriquesilveir
Resolver IV
Resolver IV

Hello, @DataGuy2016 You Cannot create new/edit measures into Power Bi Service. You can only create/edit using PBI Desktop.

 

I recommend you to read this article https://docs.microsoft.com/pt-br/power-bi/desktop-tutorial-create-measures#create-and-use-your-own-m... i believe that will help you to understand about measures.

 

Let me know if it help you! 

 

Best Regard,

 

View solution in original post

5 REPLIES 5
kashif-cg
Regular Visitor

Requirement: You need an access to the Semantic Model of the report in the workspace.

Steps:

Step#Step detailsSnapshot (if any)
1Open Workspace 
2Open Report 
3Click Editkashifcg_3-1739270142483.png

 

4Click Open Data Modelkashifcg_4-1739270165967.png

 

5Click Editing option in the right top cornerkashifcg_5-1739270181640.png

 

6Open measure, edit measure and save 
7Refresh the report already open in Edit mode in another tabkashifcg_6-1739270201951.png

 

8Save report and close to Reading View 

 

New update allows you to do so which was not possible previously. Hope this anwer your question.

v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @DataGuy2016,

 

1. The dataset in the Service will be overwritten but nothing would lose because no changes can be made in the Service. 

2. The changes to the default report in the Service could be lost. If you want to customize the report in the Service, I would suggest you make a copy of it by "Save as". This is reasonable. Because we still want to publish the new report we create in Desktop. 

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

I understand modifying the measures locally in powerbi desktop, but after republishing... im losing the utilization report.

How can that be avoided?

 

thanks a lot!

henriquesilveir
Resolver IV
Resolver IV

Hello, @DataGuy2016 You Cannot create new/edit measures into Power Bi Service. You can only create/edit using PBI Desktop.

 

I recommend you to read this article https://docs.microsoft.com/pt-br/power-bi/desktop-tutorial-create-measures#create-and-use-your-own-m... i believe that will help you to understand about measures.

 

Let me know if it help you! 

 

Best Regard,

 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors