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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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