Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
How do I switch a value in a different column based on the selected value in my dropdown?
For example:
Name | Result |
Banana | 0 |
Grape | 0 |
Strawberry | 1 |
Apple | 0 |
When i get the average of the result column it'll be 25%. If I choose Banana from my slicer, how do I get it to change the result column to 1?
Results should be:
Name | Result |
Banana | 1 |
Grape | 0 |
Strawberry | 1 |
Apple | 0 |
New average should bt 50%.
Hi @aprilbanana , you can achieve this by using parameters in Power BI
Paramaters can be found under Modelling tab and you can use numeric range and use that in your DAX
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |