page navigation based on category value

[Anonymous]

hi,

i have a card on page 1, which gets the category value based on max value of a column. on page 2 i have trends of all the categories.

i want to click on the card on page 1 and navigate to page 2 with automatically filtered on the category in page 1.

category, value

cat1, 1

cat2, 2

cat3,3

page 1 shows cat3 based on max(value), and when i click on that card/button, i should go to page 2 with cat3 filter applied.

[amitchandak]

@Anonymous , One of the ways is to have a slicer with Type(Sync with other pages)  - Tile (Orientation - Horizontal) and then have a go button near to that, that usage dynamic page navigation based on selected value

Else you need to save the page with slicer values Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4

[Anonymous]

@amitchandak  the limitation of the suggestion is that i have to create multiple pages. since the max value keeps changing i cannot keep selecting the slicer again and again.