Forum Discussion

derekli1700's avatar
derekli1700
Icon for Helper III rankHelper III
1 year ago
Solved

How to make Matrix Table invisible until Slicer is selected

Hi, i'm trying to make a matrix table invisible unless a slicer option is selected. My datasheet is comprised of 2 sheets: 1. Store A and B's monthly volume contributions 2. Store A and B's top 5 ...
Need Help
Tutorial Requests
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi derekli1700 

     

    I'm not sure if there's an easy way to do this , but try to follow the following steps and see if it works for you ?

     

    create following calculated table 

     

    support = 
UNION ( 'Unique Stores', { BLANK () } )

     

    make an inactive relationship between unique store table

     

    create this measure 

    Select Status = 
VAR _countSelected =
    COUNTROWS ( ALLSELECTED ( 'Unique Stores'[Stores] ) )
VAR _countAll =
    COUNTROWS ( ALL ( 'Unique Stores' ) )
VAR _countAllNonBlank =
    COUNTROWS ( ALLNOBLANKROW ( 'Unique Stores'[Stores] ) )
RETURN
    IF (
        _countAll = _countSelected,
        "N",
        IF ( _countSelected <> _countAllNonBlank, "Y", "A" )
    )

    add this measure to the matrix filter and apply these rules 

    hide blank from your filter and add Unique Stores[Store] column to the matrix visual and it should work 

     

     

     

derekli1700's avatar
derekli1700
Icon for Helper III rankHelper III
1 year ago

Hi - this works really well thanks. If for instance, i selected multiple stores (my actual dataset has multiple stores), is there a way so a store row can be applied to differentiate each store's overall contribution?

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
1 year ago

Hi derekli1700 

 

I'm not sure if there's an easy way to do this , but try to follow the following steps and see if it works for you ?

 

create following calculated table 

 

support = 
UNION ( 'Unique Stores', { BLANK () } )

 

make an inactive relationship between unique store table

 

create this measure 

Select Status = 
VAR _countSelected =
    COUNTROWS ( ALLSELECTED ( 'Unique Stores'[Stores] ) )
VAR _countAll =
    COUNTROWS ( ALL ( 'Unique Stores' ) )
VAR _countAllNonBlank =
    COUNTROWS ( ALLNOBLANKROW ( 'Unique Stores'[Stores] ) )
RETURN
    IF (
        _countAll = _countSelected,
        "N",
        IF ( _countSelected <> _countAllNonBlank, "Y", "A" )
    )

add this measure to the matrix filter and apply these rules 

hide blank from your filter and add Unique Stores[Store] column to the matrix visual and it should work