Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
MickeyWilliams
Frequent Visitor

Field Paramenter Slicer Side Effect

I just discovered a challenging side effect from using a field parameter slicer to define a column value in a matrix visual.  The following parameter slicer enables the user to select a specific value from the date table to define the column definition in the visual:

 

Period Slicer = {

    ("Day", NAMEOF('Date Table'[Date]), 0),

    ("Month to Date - MoM", NAMEOF('Date Table'[Year Month Name]), 1),

    ("Month to Date - YoY", NAMEOF('Date Table'[Year Month Name 2]), 2),

    ("Full Month - MoM", NAMEOF('Date Table'[Year Month Name]), 3),

    ("Full Month - YoY", NAMEOF('Date Table'[Year Month Name 2]), 4),

    ("Quarter to Date - QoQ", NAMEOF('Date Table'[Year Quarter Name]), 5), 

    ("Quarter to Date - YoY", NAMEOF('Date Table'[Year Quarter Name 2]), 6),

    ("Full Quarter - QoQ", NAMEOF('Date Table'[Year Quarter Name]), 7),

    ("Full Quarter - YoY", NAMEOF('Date Table'[Year Quarter Name 2]), 8),

    ("Year to Date", NAMEOF('Date Table'[Year]), 9),

    ("Full Year", NAMEOF('Date Table'[Year]), 10)

}

 

The problem is that when the user clicks on a specific column, it does not filter the Date Table. (see the Filtered Date Min and Filtered Date Max card values)

 

MickeyWilliams_0-1697209601218.png

 

How can I get the Date Table to filter itself by the selected column or collection of selected columns using this field parameter method?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@MickeyWilliams , Not very clear, I have used field parameter in Matrix column and when I click on that, it do filter dates, yiou can see on cards

 

amitchandak_0-1697214720244.png

 

 


Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
MickeyWilliams
Frequent Visitor

I've tried several iterations of your example, but can't get it to work.  Can you provide the pbix for your above example?  Thank you.

amitchandak
Super User
Super User

@MickeyWilliams , Not very clear, I have used field parameter in Matrix column and when I click on that, it do filter dates, yiou can see on cards

 

amitchandak_0-1697214720244.png

 

 


Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.