Table\Matrix with the ability to interactively change values

[8shipsbynight]

Is there a way to create a Table\Matrix that allows a user to interactievely change values? As you can see below, the Matrix is set up to show "Price", but what if I wanted the user to easily change this to "Cost" or "Margin"... can this be created in a way that allows a user to switch the table's values?

Here is a very simple pbix file with data: https://www.dropbox.com/s/swygxei13r0kg66/example.pbix?dl=0 

[PaulDBrown]

@8shipsbynight 

See if this article helps:

Create a hybrid or custom matrix 

[mahoneypat]

You can create dynamice measures to do that.  This article shows how.

Power BI DAX Dynamic Measures – Data on Wheels – Steve & Kristyna Hughes (wordpress.com)

Regards,

Pat

[8shipsbynight]

Thanks. I'm currently using a dynamic measure in my PBIX and it works great when assessing a single column of data and aggregating a single way. However, I'm trying to incorporate the MIN, AVG, and MAX. The site you shared with me is also calculting a single value - appears to be SUM in the site's case.

[aj1973 · Accepted solution]

Hi @8shipsbynight 

Check this out

https://drive.google.com/file/d/13QnNrMn12L7q2hnNhTqkk3Lh8aaEOwkj/view?usp=sharing

[8shipsbynight]

This looks good. I think I can work with this! Thank you