Slicers and page navigation

[Anonymous]

I ahve one slicer with column using is TYPE, it will be always having two values, Parts, vehicles and also I have enabled select all
I should have button also. If I select Vehicles in the slicer and click on button it should navigate to Vehicles page, If i select Parts in the slicer and click on button it should navigate to Parts page, If I Click on Select All in the slicer and click on button it should navigate to Parts & Vehicles page.
And also in the main page where we have slicer the charts should filter based on selection in slicer
How to achieve it

Please help

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous 

Please try this:

Here I create a set of sample:

Then create 4 page in the report:

Next add a measure:

MEASURE =
VAR _selected =
    VALUES ( 'Table'[Select] )
VAR _Slicer =
    IF (
        ISFILTERED ( 'Table'[Select] ),
        CONCATENATEX ( _selected, [Select] ),
        BLANK ()
    )
RETURN
    SWITCH (
        _Slicer,
        "Parts", "Parts",
        "Vehicles", "Vehicles",
        "VehiclesParts", "Vehicles&Parts"
    )

add a Slicer and a button in the main page:

Put the measure in the Style > Text and Select Page navigation in the action and put the measure in the Destination.

The result is as follow:

Best Regards

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

[Anonymous]

Hi

Create a measure such that

Page Navigation= switch(True(),

Selectedvalue(TYPE) = "Parts", "Parts",

Selectedvalue(TYPE) = "Vehicle", "Vehicle",

"Parts&Vehicle")

Put this measure in button-action-page navigation 

On the main page, the slicer will filter the values by default.

[Anonymous]

Hi @Anonymous ,
This helped me Thanks!!

Can you please help me on other thing like, if I select one carrier code in table chart in main page it should also filter that in the Navigation page
How to achieve please tell me if you know

Thnaks!!

[Anonymous]

Hi @Anonymous 

If your current issue has been resolved, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.

And if you meet the new problem, please post a new post on the forum.

Thank you very much for your kind cooperation.

Best Regards

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