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.
Dear All,
I'm struggling with a simulating scenario issue.
What I have is the following (sample here: https://drive.google.com/drive/folders/1MVy3gaikJeTU0HA9pvtZq503w4BW7b3T?usp=sharing 😞
Through the slicer I am able to select a project and vary the values in "simulating demand".
My problem is that, when I select another project, that value comes back to the original, which is the one in "demand".
Is there a way to maintain the simulated values when I'm switching to the other projects?
Maybe the only solution is changing values at the level of source tables, but is there any chance I can do this with a parameter?
Thank you for helping on this.
Solved! Go to Solution.
Hi @gianmarco ,
According to my understanding,
1. Firstly you select Project1 and What-if Parameter =0.2 , then simulating demand =120.
2. When switch to Project2 , Parameter still=0.2, you want to remain Project1 =120 and also show Project2 =60,right?
If the Parameter do not need change, I'd suggest you use multiple selections in slicer at one time and modify you [Measure]:
Measure = IF(MAX(project[project]) in ALLSELECTED(slicer_project[slicer_project]),MAX(demand[demand])*(1+[Parameter Value]),MAX(demand[demand]))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gianmarco ,
According to my understanding,
1. Firstly you select Project1 and What-if Parameter =0.2 , then simulating demand =120.
2. When switch to Project2 , Parameter still=0.2, you want to remain Project1 =120 and also show Project2 =60,right?
If the Parameter do not need change, I'd suggest you use multiple selections in slicer at one time and modify you [Measure]:
Measure = IF(MAX(project[project]) in ALLSELECTED(slicer_project[slicer_project]),MAX(demand[demand])*(1+[Parameter Value]),MAX(demand[demand]))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thx, Sounds good enough 🙂
@gianmarco , You can have a few independent project slicers and use that in different measures and create a comparison
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |