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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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