Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Single- vs multiple-value-slicer - how to model?

Hi,

 

I have single-value-slicer:

(Upper right, "juridicial form": Company is either an AG or an VVag...)

Works fine. If I have selected "AG" a company is shown, if I select AG and VVaG, both companies are shown...

 

But I have an issue with "multiple-value-slicers": Only companies which fulfill several criterias (e.G. no Kohleabbau, no Massentierhaltung...shall be shown.

 

However, this does not work at all!

 

What am I missing? My model looks like this:

 

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

     

    When you select all values in a slicer or select none values, the result is same. You will find that when you add a new slicer into the report, by default it selects none item and other visuals will show all data. 

     

    Best Regards,
    Community Support Team _ Jing

  • Anonymous when you say those values shouldn't show, do you mean in the slicer?

  • Anonymous's avatar
    Anonymous
    Not applicable

    No, it`s ok that the slicers don´t affect each other.

     

    The slicers only affect the bars - or at least: Do so for the single-value-slicers.

    The multiple-value-slicers (Has no Kohleabbau, no Massentierhaltung...) do not work at all!