- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you filter Field Parameters based on another slicer?
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)
}
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-03-2024 09:20 PM | |||
Anonymous
| 10-24-2022 04:21 AM | ||
07-25-2024 06:03 AM | |||
10-18-2023 01:30 AM | |||
07-23-2024 07:37 AM |
User | Count |
---|---|
24 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
19 | |
14 | |
14 | |
13 | |
13 |