Field parameter not fully updating table/matrix table

[mlim0806]

Hello, 

I created a field parameter but it is not updating my table/matrix table how I expected. When I drag the field parameter to my columns or values, select a paramter, I can see the count of my selection, however, the table values do not reflect that count. 

For example, I select "Group A" in my paramters, I expect my table to only show Group A folks, however, it is still showing Group A, B, & C groups. Is there anyway I can only have my table reflect the parameter I select?

[v-sgandrathi]

Hi @Ashish_Excel,

Thank you for the clarification. Since the Groups in your scenario are derived using a calculated measure with conditional logic (e.g: IF statements), this limits the ability to use them directly in a slicer, as slicers require column-based data rather than measures.

To enable slicer driven filtering based on this logic, we recommend creating a calculated column that mirrors the same logic used in your measure. Unlike measures, calculated columns are evaluated at the row level and can be added to slicers.

Once the column is created, you can add it to a slicer visual. Selecting a group from the slicer will then correctly filter your table or matrix visual to display only the corresponding rows, achieving the expected filtering behaviour without the use of field parameters.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.

[v-sgandrathi]

Hi @mlim0806,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @mlim0806,

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-sgandrathi]

HI @mlim0806,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

Your understanding and patience will be appreciated.

[Ashish_Excel]

Hi,

Share the download link of the PBI file and show the problem there.  Show the expected result as well.

[v-sgandrathi · Accepted solution]

Hi @mlim0806,

Thank you for reaching out.

 We understand that you are experiencing an issue where a field parameter created in Power BI is not filtering the table or matrix visual as expected. Specifically, when a selection like “Group A” is made using the parameter slicer, the visual continues to display data for all groups instead of only the selected one. This behaviour occurs because field parameters in Power BI are designed primarily for dynamically switching between columns or measures in a visual, not for filtering row-level data.

To achieve the expected filtering effect, we recommend using a regular slicer that directly references the data column.
For instance, using the Group column from your dataset  in a slicer visual. Once this slicer is added to your report and a group is selected, the table visual will automatically filter to show only the rows corresponding to that selection, such as only records for “Group A.” This method ensures that the visual reflects the correct subset of data based on user input. Field parameters remain useful for dynamic content switching in visuals, but are not suitable for applying data filters at the row level.

Additionally, I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.

Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.

Than you.

[mlim0806]

the Groups are created by a calculated measure with some IF statements. Is there a way to conver the measure into a slicer without having to use parameters?

[pankajnamekar25]

Hello @mlim0806 

Create measure 

Show Selected Group =

SWITCH(

    SELECTEDVALUE('Field Parameter Table'[Name]),

    "Group A", IF(MAX('Data'[Group]) = "Group A", 1, 0),

    "Group B", IF(MAX('Data'[Group]) = "Group B", 1, 0),

    "Group C", IF(MAX('Data'[Group]) = "Group C", 1, 0),

    1

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[mlim0806]

Hi Pankaj, 

can you clarify what values go here "'Data'[Group]"? Is it my table where I created the field parameter?