cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Uma_Dhandpani Helper I
Helper I

Values can be user defined in Power BI

Whether we can edit the report manually in Power BI. For example, in matrix table the value for sales amount is calculated and the total is enabled in subtotal format, we can edit the total value by giving some other values directly.

1 ACCEPTED SOLUTION

Accepted Solutions
JosefPrakljacic Solution Sage
Solution Sage

Re: Values can be user defined in Power BI

Either your write a measure that uses the parameter value but then you have kinda a "textbox" where you edit the number or if you insist on editing the value within the matrix you need to use tools like poweronbi.com or the powerapps visual

View solution in original post

10 REPLIES 10
Super User I
Super User I

Re: Values can be user defined in Power BI

Hi @Uma_Dhandpani,

 

I think you can try to use "Parameter" feature,

also, if you can give a sample, that is better.

 

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




JosefPrakljacic Solution Sage
Solution Sage

Re: Values can be user defined in Power BI

Hello Uma, 

 

You need to use the "Whaf-If Parameter" functionality. You use the Parameter Measure within your "Calculation Measure"

Here you have a good explanation how to do it -> https://www.youtube.com/watch?v=7IEYHMvqZHY

 

If this post was helpful please like/mark it as a solution.

 

@Uma_Dhandpani I whish you a nice day.

 

BR,

Josef

Uma_Dhandpani Helper I
Helper I

Re: Values can be user defined in Power BI

Hi,

Actually the doubt is whether  the 'total' column can be edited (i.e) as the user requirements the value can be changedCapture3.PNG

JosefPrakljacic Solution Sage
Solution Sage

Re: Values can be user defined in Power BI

Hi Uma 

 

would you please rephrase your question/remark. I'm sorry but I can't understand you here.

The total could be manipulated with a parameter.

 

Could you share an example with your data, your "imagined" process and the expected outcome.

 

Thanks Smiley Happy

 

BR,

Josef

Super User I
Super User I

Re: Values can be user defined in Power BI

Hi @Uma_Dhandpani,

 

I think you may need to tell us how you calculate the "total" now?

Also, how do the users want to change the "total"?

 

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Uma_Dhandpani Helper I
Helper I

Re: Values can be user defined in Power BI

Hi,

Whether we can edit the value of total directly in the report

JosefPrakljacic Solution Sage
Solution Sage

Re: Values can be user defined in Power BI

You can edit it via the parameter.

 

You have your parameter measure called parameter1

 

And you have a measure measure1 which your are using for your total calculation.

 

You could for instance rewrite measure1 like this

measure1 := SUMX(Your_Table, Your_Table[Quantity]-parameter1)

 

Please add an example with your data and expected results...

Uma_Dhandpani Helper I
Helper I

Re: Values can be user defined in Power BI

Hi,

Herecomes no logic, just I want to edit the value in the table field (i.e) instead for 1274, 1200 or 1278...directly in report

JosefPrakljacic Solution Sage
Solution Sage

Re: Values can be user defined in Power BI

Either your write a measure that uses the parameter value but then you have kinda a "textbox" where you edit the number or if you insist on editing the value within the matrix you need to use tools like poweronbi.com or the powerapps visual

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors