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
reggiebob
Frequent Visitor

Field Parameter Slicer

Hello,

 

I am using a field parameter slicer to dynamically change the rows in a matrix table, they can select employee, contract, product type, etc. I call this the Metric Selection slicer.

 

I also have a slicer to change how the data is viewed by the type of data, they can select bikes or cars. I call this the Page View slicer.

 

The issue I am running into is when, lets say, the user selects bikes from the Page View slicer and contracts from the metric slicer a blank row with a summation of values appears. This shouldn't be appearing since there are no bikes under a contract.

 

What's appearing:

reggiebob_1-1715784573608.png

 

 

 

What should appear:

reggiebob_3-1715785136579.png

 

To resolve this I created a the following metric parameter filter measure:

reggiebob_0-1715784492183.png

 

 

 

 

 

 

 

I then added as visual filter to only show values equal to 1 which solved the issue, so I thought.

 

Now, when users select more than one Metric Selection, employee and product type for example, no values appear...unless I take off the visual filter I just added. But I can't remove this filter since I do not want any blank row values to appear on the other metric selections.

 

Ultimately, what I need to happen is if the user selects a metric selection that doesn't relate to the page view they selected no values should appear in the matrix table. Or if the user selects more than one metric selection that relates to the page view they've selected values should appear.

 

Any suggestions on how to accomplish this?

2 REPLIES 2
v-heq-msft
Community Support
Community Support

Hi @reggiebob ,
Based on your description, you want to make sure that the matrix table displays the correct data without unnecessary blank rows or incorrect summation. We can't analyze your problem based on the available screenshots, please provide detailed test data, including the relationship between the tables, so we can better help you.

Best regards,
Albert He

@v-heq-msft Here's the link with explanations of what I want and what it's doing. I hope it makes sense: Report 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.