Forum Discussion

gilr1975's avatar
gilr1975
Helper I
6 years ago

dynamic reports using slicers

Hello,

I have 2 slicers on my dashboard.

I would like to create visuals based on each slicer.

I mean, if I use slicer 1, a chart1 will be created only using information from slicer 1.

If I use slicer 2, chart1 will be created by only using slicer2 information and not using also slicer 2.

For example:

slicer 1: Units names

Slicer 2: Category names

 

Table: EmpId, Salary, Unit, Category

 

If I choose a unit from a slicer 1, then I will create a visual chart Salary by Units

If I choose a unit from a slicer 2, then I will create a visual chart Salary by Category - and not use Units from slicer1.

If I choose a unit from a slicer 1 & slicer 2 then I will create a visual chart Salary by Category in Units.

 

Currently, even when I choose slicer 2, it still takes into consideration Units as well and then a chart is presented Salary by Category in Units.

 

How can I configure not to take slicer information if it was not chosen?