Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
QtyOrPercent =
VAR Selection = SELECTEDVALUE('View Options'[Options])
RETURN
SWITCH(
TRUE(),
Selection = "By Percentage", [QTY %],
Selection = "By Quantity", [QTY]
)
I have this measure above and basically I am switching to either percentage or just the plain sum based on the selected option on the slicer. My issue is I want to add a percentage symbol if the percentage option is selected. Using the Formatting option isn't viable here as it would turn the plain Quantity value into a percentage as well.
What are my options here? I tried doing something like below but it didn't work and my line graph became empty.
QtyOrPercent =
VAR Selection = SELECTEDVALUE('View Options'[Options])
RETURN
SWITCH(
TRUE(),
Selection = "By Percentage", FORMAT([QTY %], "Percent"),
Selection = "By Quantity", [QTY]
)
@RingoSun , I think you should consider the field parameter for this release in May 2022, or the calculation group
Discussed both in Blog and video at the end of blog - https://medium.com/@amitchandak/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9a...
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 41 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 32 | |
| 27 | |
| 26 |