Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
See if this article helps:
Create a hybrid or custom matrix
Proud to be a Super User!
Paul on Linkedin.
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
To learn more about Power BI, follow me on Twitter or subscribe 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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
138 | |
70 | |
65 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |