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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CloudMonkey
Post Prodigy
Post Prodigy

How to create table visualisation of unmapped items

Hi,

 

I have uploaded a test Power BI file to https://ufile.io/tw3of

 

I have two tables: "Car" and "Wheel Sizes", and I need to create a table visualisation listing the cars that do not have a mapping to the "Wheel Sizes" table. Pleaes can you help me create the table visualisation? (I know how to filter a table by 'blank' items, but don't know how to show completely unmapped items)

 

Mapping:

screenshot1.JPG

 

Input tables:

Car.JPG

 

Wheel sizes.JPG

 

Current table visualisation (it is wrong, it should output the cars with no mapping to wheel size: "BMW" and "Mazda"):

output.JPG

Thank you for your help,

 

CM

 

1 ACCEPTED SOLUTION
CloudMonkey
Post Prodigy
Post Prodigy

The fix was to "Don't Summarize" the "Wheel Size" field, then to filter "Wheel Size" by blanks.

View solution in original post

1 REPLY 1
CloudMonkey
Post Prodigy
Post Prodigy

The fix was to "Don't Summarize" the "Wheel Size" field, then to filter "Wheel Size" by blanks.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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