- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Toggle the value of a measure to 0
Hello all,
I need some help on this idea.
Let´s say I have a measure that calculates some money. Let´s say it shows 100,000$.
Now I want the user of the report to be able to toggle this measure to 0$ - just to see what would happen to other measures if this certain measure was 0.
The user could use a slicer or a filter to toggle the value to 0 and (in this example) back to 100,000$.
I do not have the right initial idea how to achieve this 😞
Thank you in advance for any ideas!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes, in such cases, what-if parameter saves the day.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes, in such cases, what-if parameter saves the day.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It really saved my day 🙂
Created a what-if parameter with just two states: 0(%) and 100(%).
Then I multiply my measure with the selected state of the what-if-parameter.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@cosmicyes , Create a table with two values Actual , hide
Then You can have measure
meausre new = if(selectedvalue(Table[Show]) = "hide",0, [Measure])
You can use old measure slicer approach or field parameter too with a measure having value =0
How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, I will check both approaches.
May I ask you: what would you recommend? Measure Slicer or Field Parameters?
I have heard about Field Parameters and think this is "the future"?
Thank you again in advance
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-13-2024 09:19 AM | |||
12-16-2022 07:49 AM | |||
04-24-2024 12:44 PM | |||
04-03-2024 09:53 AM | |||
02-22-2024 09:30 PM |
User | Count |
---|---|
126 | |
81 | |
59 | |
57 | |
43 |
User | Count |
---|---|
183 | |
111 | |
82 | |
65 | |
50 |