The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I wonder if is possible to hide a text box based in the value of a measure.
Thanks.
Solved! Go to Solution.
Hi FinYui8,
You can overlap the textbox with a shape rectangle and set its Fill transparency to 0 based on measure value. Please follow the steps below:
1. Overlap the textbox with a shape rectangle. Only fill should be enabled, Background and border must be disabled.
2. Create a measure with IF condition - If(specific measure value(condition), "rgba(255,255,255,1)","rgba(255,255,255,0)"). 0 - denotes 0% transparency, 1 - denotes 100% transparency. You can chnage the Hex codesas per your color selection.
3. Put this measure in f(x) of Fill property. Select Field value and select this measure.
Hi FinYui8,
You can overlap the textbox with a shape rectangle and set its Fill transparency to 0 based on measure value. Please follow the steps below:
1. Overlap the textbox with a shape rectangle. Only fill should be enabled, Background and border must be disabled.
2. Create a measure with IF condition - If(specific measure value(condition), "rgba(255,255,255,1)","rgba(255,255,255,0)"). 0 - denotes 0% transparency, 1 - denotes 100% transparency. You can chnage the Hex codesas per your color selection.
3. Put this measure in f(x) of Fill property. Select Field value and select this measure.
Hi @Anonymous ,
we can show or hide the measure value in Text box and visual is transparent it will look like hidden but technically it is not!
Thanks.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
78 | |
66 | |
52 | |
51 |
User | Count |
---|---|
121 | |
116 | |
77 | |
64 | |
63 |