Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

How to pre-select multiple slicers and hide the pre-select value?

Hi, I wanna show the customer location and technician location in the map. But, when I append these 2 tables, the slicers seem to be confusing to filter.

For example,

  • when I want to view the location of Product Group = Group-1 and the location of technician, I have to do multiple selections which is "Group-1" and "(Blank)". 
  • when I want to view the location of customer and the technician with role = Engineer, I have to select both "Customer" and "Engineer".
  • when I want to view the location of Team A and location of customer, I have to select "Team A" and "(Blank)".

This cause some confusion when I select multiple slicers.

How to pre-select "(Blank)" and Role=Customer and hide those selection from the list?

Sample file here.



Super User III
Super User III

Very similar problem to this one here

Solved: Re: Show adress from one customer and the supplier... - Microsoft Power BI Community

In short, you can't do that.  What you can do is manipulate the bubble sizes via measures.

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.