CODEWITHSUNDEEP
powerbidaxpowerquerypowerbi-desktoppowerapps
Remsset_HP
Remsset_HP

Reputation: 51

How to create a Parameter column/Editable column for a table or matrix visual?

I need a column on a table visual or matrix visual in which values can be inserted or edited on the published dashboard only for visual purposes (without persisting the data or writing it anywhere). Like inserting a parameter or a value on an Excel table.

The table has a Proposed Purchase column, and I just need an editable column next to it so the user inputs the Real Purchase they intend to make, just so the Total at the end of the table shows the sum of the Real Purchases inserted on each row.

ex.:

        Proposed Purchase | Real Purchase

                 7000     | *blank field where the user can input a value*

                 5500     | *blank field where the user can input a value*

Total:          12500     | *sum of the inserted values*

If anyone knows a solution to this or a component I can use I appreciate it.

Upvotes: 0

Views: 609

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40224

If what-if parameters are insufficient, then you need a more robust solution like:

PowerApps Custom Visual

or else a product like

Power On's Visual Planner for Power BI

Upvotes: 1

Related Questions