Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to create a dynamic Dashboard to estimate the profitability of potential investments with measures like IRR. I created a "What If" Parameter to show me how many periods an investment will last. This parameter goes from 1 to 60 months, for an example. What I need to do is to create a new table with 12 rows when users selected number 12 at "What If" parameter. Is that possible?
Thanks
Solved! Go to Solution.
Hi @Anonymous
If you are referring to calculated table when you say new table, that is not possible as it is saved back into the model upon creation and doesn't update dynamically based on slicer selections. However, a table visual and some conditional DAX measures may help you achieve your requirement. Please see image below and the link to a sample PBIX
https://drive.google.com/open?id=1OB4Zrkk8AWfZK0WoKOZLno_wrubAbb_H
Proud to be a Super User!
Hi @Anonymous
If you are referring to calculated table when you say new table, that is not possible as it is saved back into the model upon creation and doesn't update dynamically based on slicer selections. However, a table visual and some conditional DAX measures may help you achieve your requirement. Please see image below and the link to a sample PBIX
https://drive.google.com/open?id=1OB4Zrkk8AWfZK0WoKOZLno_wrubAbb_H
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |