Next and Previous Buttons To Navigate Through a Single Select Slicer
Hi everyone I have a single - select drop down menu, but the drop down has ~1500 names, it's not user friendly to go to the next person. I'd like to include a next and previous button . I have created an index column to use +1/-1 to navigate through my list. I have separate cards and a table that provides the current name, next name, and previous name, all currently showing the data correctly as I select random names in my drop down (in other words I have the correct DAX statements) I attempted to do this with bookmarks - but because there are so many names and bookmarks are static, this is not a great avenue. I attempted to do this with page navigation but it doesn't leverage the logic from my measures or calculated columns. It works in the sense that it toggles between previously tested names. I am now attempting to click on the name from the table in hopes that the next/previous name may update the slicer Has anyone come across this exercise before?
Field Parameter Returns Text Value, can not convert to number
I have created a Field Parameter and the data is all numnerical. When I choose the field measure, it returns the number value as text so I can not use it in further calculations. Any way to change the output from field parameters to numerical?
Custom text for parameter table
I have created a table with fields parameter and using this in a slicer. DAX is a follows : Tabular Options - Summary = { ("vs LY", NAMEOF('Measure Folders'[Value Options formatted ( Summary )]), 0), ("Selected Perspective", NAMEOF('Measure Folders'[Selected Perspective]), 1), ("LY Actuals", NAMEOF('Measure Folders'[LY]), 2), ("vs AOP", NAMEOF('Measure Folders'[Value Options formatted ( Summary )(AOP)]), 3), ("AOP Actuals", NAMEOF('Measure Folders'[AOP]), 4) } Now I want to change the title based on user selection. Like in the "vs LY", I want to show "vs 2022" when user selects year 2023 from fact table. Is it possible?