Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
To give a bit more info, this is the main part of how I insert the values into the SWITCH measure. Please note it's a very shortened version, but includes the two main types of values (with and without additional text)
var delta_etc_pfe_perc =
IF( LEN([Δ ETC vs PFE %]) > 0, [Δ ETC vs PFE %], 0 )
var result = SWITCH( TRUE(), /* Metric = Days */
metrics = 1 && selected_column_1 = "Planned", [Frc Days],
metrics = 1 && selected_column_1 = "Δ ETC vs PFE", [Δ ETC vs PFE] & " (" & delta_etc_pfe_perc & ")",
So in this case, my value Delta ETC vs PFE is numerical, but the variable I insert after is text because SWITCH doesn't allow me to insert numerical percentage variables, as they will become reformatted as non percentage. So I format as text the measure as I calculate it on its own as follows: FORMAT(Result, "0.00%") and then here make that if() call on it
As you can see I also added a measure to conditionally colour only some of the values, and I just want to state beforehand that changing that won't affect the result.
Why do my SWITCH measure results look like this? I already fixed the decimal number to 2 values. It only happens for those rows where I stated that it should give me both the result of an operation and then another one within parenthesis. But both of those values I also fixed to 2 decimals only
Solved! Go to Solution.
Can you try something like:
var result = SWITCH( TRUE(), /* Metric = Days */
metrics = 1 && selected_column_1 = "Planned", round([Frc Days],2),
metrics = 1 && selected_column_1 = "Δ ETC vs PFE", round([Δ ETC vs PFE],2) & " (" & delta_etc_pfe_perc & ")",
Proud to be a Super User!
Can you try something like:
var result = SWITCH( TRUE(), /* Metric = Days */
metrics = 1 && selected_column_1 = "Planned", round([Frc Days],2),
metrics = 1 && selected_column_1 = "Δ ETC vs PFE", round([Δ ETC vs PFE],2) & " (" & delta_etc_pfe_perc & ")",
Proud to be a Super User!
This got the job done precisely, thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |