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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Nash2Bos
Helper I
Helper I

How to have a table show up blank until a matrix filter is selected

Hi all i have a matrix table 

 JanFebMarAprMayJuneJuly
Replace5784 79
Buy 43 915
Install  14  76

 

I have a table with further information on the data. However right now all the data shows until you select a specific number. Is there a way to show the table as blank until a number is selected?

 

thank you in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Nash2Bos ,

 

Thank you @vicky_  for your replies, allow me to provide another insight:

 

1. create a bookmark, at this point do not display the matrix.

vkaiyuemsft_0-1715586984750.png


2. create another bookmark, at this point the slicer selects the value and the matrix displays the value at this point.

vkaiyuemsft_1-1715586994869.png

 

3. create a button that displays DD when clicked.

vkaiyuemsft_2-1715587012955.png

 

vkaiyuemsft_3-1715587012956.pngvkaiyuemsft_4-1715587025184.png

 

At this point hold down the CTRL key while clicking the DD button to display the matrix Visual Object.

vkaiyuemsft_5-1715587043208.png

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @Nash2Bos ,

 

Thank you @vicky_  for your replies, allow me to provide another insight:

 

1. create a bookmark, at this point do not display the matrix.

vkaiyuemsft_0-1715586984750.png


2. create another bookmark, at this point the slicer selects the value and the matrix displays the value at this point.

vkaiyuemsft_1-1715586994869.png

 

3. create a button that displays DD when clicked.

vkaiyuemsft_2-1715587012955.png

 

vkaiyuemsft_3-1715587012956.pngvkaiyuemsft_4-1715587025184.png

 

At this point hold down the CTRL key while clicking the DD button to display the matrix Visual Object.

vkaiyuemsft_5-1715587043208.png

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vicky_
Super User
Super User

Change the calculation for the measure you use for your matrix. Something like:
Your Measure = IF(ISFILTERED(Table[Slicer Field]), [Your numbers measure or calculation here], BLANK())

I think I got it. But the whole table is still there

For with matrix table? Right now I'm just putting the column to count everything?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors