Forum Discussion

derekli1700's avatar
derekli1700
Helper 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 

     

     

     

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

Hi derekli1700 

 

you need something like this ? 

 

 

 

 

no selection blank 

 

I have just changed the row subtotal lable to overall Store Vol.

 

the measure i have used in here is 

 

Combined Vol Measure = 
IF (
    ISFILTERED('Unique Stores'[Stores]),
    IF (
        ISINSCOPE('Unique Customers'[Customer]),
        SUM('Top 5 Customer Monthly Breakdow'[ Vol (L)]),
        SUM(Overview[Vol (L)])
    ),
    BLANK()
)

 

matrix visual row is unique customer[customer]

 

 

derekli1700's avatar
derekli1700
Helper 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