Forum Discussion
Helper IIIMake Matrix Table blank until Slicer Option is selected
Hi, i'm trying to have my matrix table be blank until a slicer option is selected and none of the youtube tutorials are working.
This is basically my table called Overview where it shows the stores and their sales volume:
| Stores | Period | Sales |
| A | Jan-24 | 64,698 |
| A | Mar-24 | 78,476 |
| A | Jan-24 | 18,605 |
| A | Mar-24 | 19,573 |
| A | Jan-24 | 8,165 |
| A | Mar-24 | 8,168 |
| A | Jan-24 | 85,787 |
| A | Mar-24 | 108,818 |
| A | Jan-24 | 10,035 |
| A | Mar-24 | 12,049 |
| A | Jan-24 | 9,127 |
| A | Mar-24 | 12,030 |
| B | Jan-24 | 30,623 |
| B | Mar-24 | 31,309 |
| B | Jan-24 | 5,717 |
| B | Mar-24 | 7,156 |
| B | Jan-24 | 1,857 |
| B | Mar-24 | 2,208 |
| C | Jan-24 | 1,994 |
| C | Mar-24 | 2,548 |
| C | Jan-24 | 438 |
| C | Mar-24 | 644 |
and i have a slicer that uses a unique list of all stores to filter on sales:
| Site |
| A |
| B |
| C |
Is there a measure that can be put on the "Filters on this visual" tab and set to " Is 1" that makes the matrix table blank until a slicer option is selected. There is alot of data in the actual sheet so i prefer the slicer list/data format stays the same
Create a measure for your slicer selection:
ShowDataFlag =
IF(
HASONEVALUE('Site'[Site]),
1,
0
)and then set the flag accordingly in your visual filters.
1 Reply
Shravan133Super User
Create a measure for your slicer selection:
ShowDataFlag =
IF(
HASONEVALUE('Site'[Site]),
1,
0
)and then set the flag accordingly in your visual filters.