Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
8shipsbynight
Helper I
Helper I

Table\Matrix with the ability to interactively change values

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?

 

8shipsbynight_0-1610661588273.png

 

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

 

 

1 ACCEPTED SOLUTION

Hi @8shipsbynight 

Check this out

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

@8shipsbynight 

See if this article helps:

Create a hybrid or custom matrix 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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.

Hi @8shipsbynight 

Check this out

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.