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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
New Member

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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