Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi friends,
how can i change measure through slicer fields from parameter, i tried the normal way using switch() but it doesnt work
parameter slicer
card with switch() measure
error details
@Anonymous,
Try this measure:
Switch Measure =
VAR vSelectedParameter =
SELECTCOLUMNS (
SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
"Parameter", 'Parameter'[Parameter]
)
VAR vResult =
SWITCH (
vSelectedParameter,
"Aging GR>1-90 days", 1,
"Aging GR>91 - 180 days", 2
)
RETURN
vResult
Proud to be a Super User!
@DataInsights it work! but just a little more, i put this measure to y axis in combo visual and if user doesnt select any slicer it will error, could you let the measure just blank or something not make visual broke?
selected one
if not select anyone on slicer
@Anonymous,
I would need to see your model or sample data. You can share a link to OneDrive, etc. One idea is to add an ELSE argument to the measure in case of no user selection:
Switch Measure =
VAR vSelectedParameter =
SELECTCOLUMNS (
SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
"Parameter", 'Parameter'[Parameter]
)
VAR vResult =
SWITCH (
vSelectedParameter,
"Aging GR>1-90 days", 1,
"Aging GR>91-180 days", 2,
"put ELSE argument here"
)
RETURN
vResult
Proud to be a Super User!
I had to add a space to each side of the hyphen between 91 and 180 due to the community requirement below:
@Natalie_iTalent do you know why this error occurred?
Proud to be a Super User!
Hello @DataInsights,
Thank you for bringing this to my attention. It has been resolved and you shouldn't have any other issues.
Best,
Natalie H.
Community Manager
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |