Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure to Filter matrixvisual by Multifilter

Hi,

 

in my matrix-visual "Multifilter" (right) filters according to "Versicherungsprodukte" (top) - but nevertheless other columns still appear, even if they do not have Results:

 

 

How do I make the rows for the other columns (containing names, logo, do-they-have-special-products/leafs) disappear?

 

At the top of my head I think I need to create a measure for the rows:

IF (
SELECTED ( ( FaktMultifilter[VALUE] ) IN {"Nachhaltige Haftpflicht", "Nachhaltige Hausrat",...}", (FaktStruktur[Basisinfo:Versicherer] ) ) )
 
and some other measures for the matrix visuals' values:
IF (
SELECTED ( ( FaktMultifilter[VALUE] ) IN {"Nachhaltige Haftpflicht", "Nachhaltige Hausrat",...}", (FaktStruktur[Basisinfo:Logo] ) )
)

 

But is there an easier way I simply don't know?

 

 
 

 

 

 

 

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    In the rows section of your visual use a dropdown next to one of the fields and uncheck "Show items with no data"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi lbendlin ,

    unfortunately it's already unchecked.

     

    I've noticed: The behaviour only occurs if I drop a measure to values. Once I've made a custom column out of it and dropped this in, everything was fine.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    here are 2 ways for your reference,

    (1) change the setting of the visual-level filter,

    (2) Or you can change the measure, add a judgment statement to measure  (see below)

    Don't forget to uncheck this option: show items with no data.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.