Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Folks,
I am looking for a way to replace the automatic total with a number I want on the Waterfall chart. Any suggestions on how to do this?
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You could take a look at ISINSCOPE() function.
https://docs.microsoft.com/en-us/dax/isinscope-function-dax .
It will return "false" at total field and you could use it with IF() function.
IF(ISINSCOPE(), result_when_true, result_when_false)
Best Regards,
Jay
Hi @Anonymous ,
You could take a look at ISINSCOPE() function.
https://docs.microsoft.com/en-us/dax/isinscope-function-dax .
It will return "false" at total field and you could use it with IF() function.
IF(ISINSCOPE(), result_when_true, result_when_false)
Best Regards,
Jay
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
154 | |
120 | |
73 | |
73 | |
63 |