Forum Discussion

JorgeAbiad's avatar
JorgeAbiad
Helper III
4 years ago
Solved

Problem with slicers

Hello PBI Experts,   I will have 2 questions to ask. 1. First, I have 3 slicers in the report which are all set to dropdown. I have also have 1 button used to clear the filters applied using slice...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi JorgeAbiad 

     

    Have you try turn off the show items with no data.

     

    If the value from resolver group is 0 instead of blank, this will no work.

    Tyr to put the group from one table into the slicer and the group from many table into the bar chart

    Or you can ues a measure to show the blank where the calculation result is zero.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi JorgeAbiad ,

 

Answers are below:

1. You button is resetting your slicers to list because you may have added those slicers after the button/bookmark was created on the report page. Simple way to fix this will be to make all your slicers as dropdown type and then update your bookmark. This will resolve this issue.

2. If you have a realtionship between the tables then it should work. But I am not clear on the filter direction on your relationship. Can you share a screenshot on the relationship you have?

 

Thanks,

Pragati

JorgeAbiad's avatar
JorgeAbiad
Helper III
4 years ago

Hello Pragati,

Thanks for prompt reply.

I think my first issue is resolved.

For the second, below is the relationship  (m->1), and the cross filter direction is Single

When I select a value from Competence Center slicer, correct values are displayed in the resolver group slicer. But when when the same resolver group is used in stacked bar chart, all resolver group values are displayed. I am expecting to have the same values displayed in the resolver group s;icer.

Below is my bar chart. It should only contain 3 values, but it is displaying all the values from the resolver group. The values that are to be excluded are highlighted in yellow.

 

 

 

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi JorgeAbiad 

     

    Have you try turn off the show items with no data.

     

    If the value from resolver group is 0 instead of blank, this will no work.

    Tyr to put the group from one table into the slicer and the group from many table into the bar chart

    Or you can ues a measure to show the blank where the calculation result is zero.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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