cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jzimmem
New Member

Will the Power BI Designer "Create Measure" interface be changed to be in the context of the columns

Will the Power BI Designer "Create Measure" interface be changed to be in the context of the columns similar to PowerPivot and Visual Studio today. I find it awkward to create a measure without actually seeing the columnar sources and results in the same screen.

2 ACCEPTED SOLUTIONS
LanceDelano
Microsoft
Microsoft

The future of creating a calc column will definitely include context.  This will play out in a couple of ways.  Give us a month or so and you'll be begin to see how it will work.

Lance

View solution in original post

andre
Memorable Member
Memorable Member

I also hope that the current tabular interface for measures will go away. Some sort of a folder/tree like structure that would allow to easily find and organize measures would be great.

 

Also, dealing with MTD/QTD/YTD, Var to Plan, Var to Forecast, Var to Last Year, Var %... somehow needs to be addressed so that we don’t end up having to write/organize 5-10 different variations of the same measure over and over again like we have to do today.

View solution in original post

5 REPLIES 5
andre
Memorable Member
Memorable Member

I also hope that the current tabular interface for measures will go away. Some sort of a folder/tree like structure that would allow to easily find and organize measures would be great.

 

Also, dealing with MTD/QTD/YTD, Var to Plan, Var to Forecast, Var to Last Year, Var %... somehow needs to be addressed so that we don’t end up having to write/organize 5-10 different variations of the same measure over and over again like we have to do today.

LanceDelano
Microsoft
Microsoft

The future of creating a calc column will definitely include context.  This will play out in a couple of ways.  Give us a month or so and you'll be begin to see how it will work.

Lance
gbrueckl
Regular Visitor

Hi jzimmem,

 

I am not aware of any plans to make the interface similar to the one that you know from PowerPivot/VS. In some ways i like this new approach of creating new measures measures, however, when the model gets big and you have 50+ measures this will be a pain to maintain. Maybe you should fill a feature request for this.

 

hth,

-gerhard

I think (or hope!) that the feedback is not about having the measure grid "as is"; but having a way to display the result of measures and calculated colunmns in a "test" environment. In the PP measure grid you see the result of the measure in a certain filter context (defined by current table filters) and you also see the value of the calculated column for each row of the table. This is completely missing today in Power BI Designer and this is the type of UI that is required, IMHO.

 

Marco

You will see us making updates in this area in our next update. I am not sure if this will be exactly what you want but it will definetly be in the direction you are pointing out to.

 

I am sure there will be follow up questions once the update is released but over all the answer should be "yes".

 

Stay tuned.

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!