dynamic reports using slicers

[gilr1975]

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?

[amitchandak]

@gilr1975 , refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

if you want to change axis then you have to use a bookmark

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive