Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
7 years ago
Solved

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 ...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    7 years ago

    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. 

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
7 years ago

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's avatar
    Uma_Dhandpani
    Helper I
    7 years ago

    Hi,

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

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      7 years ago

      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 :smileyhappy:

       

      BR,

      Josef

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

      • Uma_Dhandpani's avatar
        Uma_Dhandpani
        Helper I
        7 years ago

        Hi,

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