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
rax99
Helper V
Helper V

Hide blank values in matrix view

I have 2 tables containg call_IDs with a specific call direction (so table1 contains incoming, table 2 outgoing)

 

Table1:

Call_IDDirectionAttemptColdWarm
1In1018129
2In11914790
3In1523770
4In6565116
5In102127144
6In153318
7In894533
8In10535119
9In3698115
10In906622

 

Table 2:

Call_IDDirectionAttemptColdWarm
1Out2212018
2Out11911788
3Out401639
4Out948290
5Out1107651
6Out13912449
7Out11359114
8Out1301359
9Out196955
10Out50738

 

I have a 'bridging' table for the call direction to join the tables.

 

tables.JPG

 

When creating a matrix, I get the columns being duplicated on each of the grouping category, and displaying blank values like below;

matrix with blanks.JPG

 

 

 

Clearly these blanks highlighted above should not be appearing. How do I get rid of these?

 

Note. This is a simplified version of a more complex table/data structure with more calculations etc so unfortunatly I cannot combine the In/Out tables (which does fix the issue in fact)

 

See attached pbi file for full example.

PBI_File

 

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

have a look at this file
https://1drv.ms/u/s!AjxUGXgGNzCEiV4mePewl33dzvil

Capture.PNG
with the way joins are set up you don't even have to specify in/out filter cause it comes from the visual fitler context



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

10 REPLIES 10

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.