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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
chuynh5
Regular Visitor

Removing Names without removing the data points

Hello

 

I am currenty using the multi row card visual to display scores. On the multi row card visuals are names of companies. Is there a way to have a slicer remove the names of companies without removing their data while keeping the name of the company selected in the slicer.

 

What it looks like now:

 

Company Name 1 | Score

Company Name 2 | Score

Company Name 3 | Score

 

When Company Name 2 is selected:

 

xxxxxx | Score

Company Name 2 | Score

xxxxxx | Score

1 REPLY 1
amitchandak
Super User
Super User

@chuynh5 , Create a table below. Create a many to many join and keep filter direction as Name to your tbale

 

Name = addcolumns(generate(distinct('Item'[company_name]),selectcolumns(distinct('Item'[company_name]), "_name", [company_name])) , "Final", if([company_name] = [_name], [company_name], "****"))

 

Use company Name is slicer and final in visual 

 

check this for refrenece

https://medium.com/@amitchandak/power-bi-show-unselected-values-as-others-7d4857b3ceab

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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