The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
62 | |
57 | |
54 | |
51 | |
33 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
43 |