Segmented Filtering with Slicers

June 20, 2018 By Mike Carlo

This weeks tutorial focuses on the need to control groups of visuals independently. This recently came up in a project where I needed to adjust all the items on the left side of the screen independently from the right side. By using the Edit Interactions button found on the Format ribbon you are able to adjust how different visuals interact with each other. Finally, adding multiple Slicers to the page for controls finishes out the report. I hope you enjoy this weeks tutorial.

Followup:

On the demo page of the report you’ll notice that when various items are selected, some of the non-selected items dis-appear. This is handled by using some formatting within the measures for the visuals. All the measures used in this tutorial are listed below:

Taking an Average of a Numerical Column:

Average of Values = VAR calc = AVERAGE( Data[Value] ) RETURN if( calc = BLANK(), "", calc )

Making Dynamic Titles off of a list of items in a table:

Title = VAR title = CONCATENATEX( VALUES( Data[Customer] ), Data[Customer], ” & ” ) RETURN if( title = BLANK(), "", title )

Producing a sum of values:

Total of Values = VAR calc = SUM( Data[Value] ) RETURN if( calc = BLANK(), "", calc )

Want the file:

Need a little more help? Like the content from PowerBI.Tips. Please consider purchasing the demo PBIX file to support more great content.

[product id=”17894″ ]

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.