The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Good Morning,
I have a rectangle that should be shown/hidden (also other parametes within it) based on one Paramter I choose at first.
Let's say I have a parameter that's called ART and the values are "Agenda" & "Protocol"
When the users chooses "Agenda" a rectangel show be hidden and the parameters in it should be inactive.
Anyone any idea?
thanks in advance
Solved! Go to Solution.
Hi,
Follow the steps below to resolve this requirement.
1. Go to rectangle properties.
2. Go to "Visibility" window.
3. Check the option "Show or hide based on an expression."
4. Click on expression builder "fx" button.
5. In the window use IIF function to fulfill the requirement: = IIF(Parameters!ART.Value = "Protocol", False, True).
This hides the rectangle and once rectangle is hidden, data in it will be hidden too.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Follow the steps below to resolve this requirement.
1. Go to rectangle properties.
2. Go to "Visibility" window.
3. Check the option "Show or hide based on an expression."
4. Click on expression builder "fx" button.
5. In the window use IIF function to fulfill the requirement: = IIF(Parameters!ART.Value = "Protocol", False, True).
This hides the rectangle and once rectangle is hidden, data in it will be hidden too.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey,
It finally worked - Thanks a lot. At first it din't work at all but then i figured out, that I wrote the Parameters in german language and Protocol is written "Protokoll". 🙂
Have a great day!