question

kBoss-8405 avatar image
0 Votes"
kBoss-8405 asked emilyhua-msft commented

Filter matrix colum with a button

Hii Everyone,

I want to create a button on my current page to filter my matrix column.
In my colum, colum 7, are 1's and 0's. I want to create a button on top to filter all the 1's.
Is this possible and if so, how do i do this?
I have looked for the possibilities with bookmarks but i dont know how to filter all the 1's. (Those are the values i want to see)

thanks in advance


office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Lz-3068 avatar image
1 Vote"
Lz-3068 answered

Hi @kBoss-8405

Column #7 should be column G if I make no mistake. So:

PIC

  • In G1 enter something, i.e. MATRIX

  • Keep G1 selected

  • Go to Excel Home tab

  • Sort & Filter > Filter (the button you expect should now be visible next to MATRIX)

  • Click on that button > Uncheck 0


demo.png (5.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

@kBoss-8405

If you are using Microsot Power BI, I would suggest you post a new thread on following forum. As tag "office-excel-itpro" focus more on general issue of Excel client.

Microsoft Power BI Community

If you are using Microsoft Excel, please refer to Lz-3068's reply.

Any questions, please let us know.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@kBoss-8405
I am checking this thread, is there any update?
If yes, you may post back.

0 Votes 0 ·