Can you filter Field Parameters based on another slicer?

[ptmuldoon]

I've created a field parameter that of list out various Daily and Monthly calculations.  And if I chose each item in the Parameters I get the desired result.  But is there a way to filter the field parameters based on another slicer/filter?

I am trying to find how to show only the Daily or Monthly Parameters based on the that selection from another slicer.

I have a small slicer/filter for Daily/Monthly

And then I have a list of Parameters as below.    Is it possibly to create a relationship to filter the parameters based on month/daily filter?

Periods Parameter = {
    ("Day", NAMEOF('Fact Periods'[Period Day]), 0),
    ("Day Last 7", NAMEOF('Fact Periods'[Period Day Last 7]), 1),
    ("Day Last 14", NAMEOF('Fact Periods'[Period Day Last 14]), 2),
    ("Day Last 21", NAMEOF('Fact Periods'[Period Day Last 21]), 3),
    ("Day MTD", NAMEOF('Fact Periods'[Period Day MTD]), 4),
    ("Day QTD", NAMEOF('Fact Periods'[Period Day QTD]), 5),
    ("Day YTD", NAMEOF('Fact Periods'[Period Day YTD]), 6),
    ("Month", NAMEOF('Fact Periods'[Period Month]), 7),
    ("Month T3M", NAMEOF('Fact Periods'[Period Month T3M]), 8),
    ("Month T6M", NAMEOF('Fact Periods'[Period Month T6M]), 9),
    ("Month T9M", NAMEOF('Fact Periods'[Period Month T9M]), 10),
    ("Month T12M", NAMEOF('Fact Periods'[Period Month T12M]), 11),
    ("Month QTR", NAMEOF('Fact Periods'[Period Month QTR]), 12),
    ("Month YTD", NAMEOF('Fact Periods'[Period Month YTD]), 13)
}

[Gabry · Accepted solution]

Hello @ptmuldoon ,

sure you can. You can look at parameters like tables. You need to add a column to your first parameter, with value monthly or daily, then you create a second table with 1 column, 2 rows (daily and monthly) then you build a relationship between these 2 tables 1:*. Then you use the first table as a filter

Hope I made my point, let me know