Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi all i have a matrix table
Jan | Feb | Mar | Apr | May | June | July | |
Replace | 5 | 7 | 8 | 4 | 7 | 9 | |
Buy | 4 | 3 | 9 | 1 | 5 | ||
Install | 14 | 7 | 6 |
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.
Solved! Go to Solution.
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.
2. create another bookmark, at this point the slicer selects the value and the matrix displays the value at this point.
3. create a button that displays DD when clicked.
At this point hold down the CTRL key while clicking the DD button to display the matrix Visual Object.
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.
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.
2. create another bookmark, at this point the slicer selects the value and the matrix displays the value at this point.
3. create a button that displays DD when clicked.
At this point hold down the CTRL key while clicking the DD button to display the matrix Visual Object.
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.
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?
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |