Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I have a scenario where I have measures on below
cancelled in 15 days, cancelled in 30 days, cancelled in 45 days, cancelled in 60 days( 4 measures)
paid in 15 days, paid in 30 days , paid in 45 days, paid in 60 days(4 measures)
unpaid in 15, 30, 45, 60 (4 measures)
all the days performace are from issued date(eg: paid in 15 days from the issued date. cancelled date is also used for cancellations)
I need to create a measure slicer where i need this measure names as filter. when i pick 15 days in slicer it should slice my table for all paid, cancelled, unpaid with 15 days performace.
Can you guys help me on this please?
Note: I just simplified the scenario, would it be possible to create a measure slicer with filed parameters, when i have mulitple measures for one category.
i did not go for calculation groups as i have no idea how to pull the calculation groups in measure slicer. in table the output should be like measures in rows and measures in values. cancelled, paid and unpaid should be rows(these are DAX calculations not an actual value in column)
Thanks in advance
Solved! Go to Solution.
Hello @01UmaManoharan,
Can you please try the following:
1. Create a Disconnected Table for the Slicer
TimeFrameSlicer = DATATABLE(
"TimeFrame", STRING,
"Days", INTEGER,
{
{"15 days", 15},
{"30 days", 30},
{"45 days", 45},
{"60 days", 60}
}
)
2. Create Dynamic Measures
DynamicMeasure =
VAR SelectedTimeFrame = SELECTEDVALUE(TimeFrameSlicer[Days], 15)
RETURN
SWITCH(
SelectedTimeFrame,
15, [YourMeasureFor15Days],
30, [YourMeasureFor30Days],
45, [YourMeasureFor45Days],
60, [YourMeasureFor60Days],
BLANK()
)
Hope this helps!
Hello @01UmaManoharan,
Can you please try the following:
1. Create a Disconnected Table for the Slicer
TimeFrameSlicer = DATATABLE(
"TimeFrame", STRING,
"Days", INTEGER,
{
{"15 days", 15},
{"30 days", 30},
{"45 days", 45},
{"60 days", 60}
}
)
2. Create Dynamic Measures
DynamicMeasure =
VAR SelectedTimeFrame = SELECTEDVALUE(TimeFrameSlicer[Days], 15)
RETURN
SWITCH(
SelectedTimeFrame,
15, [YourMeasureFor15Days],
30, [YourMeasureFor30Days],
45, [YourMeasureFor45Days],
60, [YourMeasureFor60Days],
BLANK()
)
Hope this helps!