The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have created a Period Slicer with options to choose from Day Week Month Year Lifetime Custom with Single Select. Now using Left and Right Arrow Buttons - is it possible to make it dynamic Left Arrow for Previous and Right Arrow for Next for users to choose Day and click Previous and same for Next with or without using dax measures. I have created a card visual with dynamic date between Left and Right Arrow which changes Date dynamically based on created dax measure but the left and right arrow buttons are not working. Can somebody guide me through this? Once the slicer and dynamic arrows work, i want to integrate Line Chart for Day and Column Chart for Week Month Year Liftetime and Custom
Hi @rooftopurja,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
Hi @rooftopurja,
Could you share a sample PBIX file that shows the issue? This will help us understand the situation better and offer a more precise solution.
Thank you.
i dont find any option to attach pbix files here.
rooftoprescoprojects.pbix - onedrive link - confirm if you can access the file now.
data in pbix file is in directquery mode with sql database - i am able to access the visuals in power bi desktop -
Hi @rooftopurja,
We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.
Thank you.
Hi @rooftopurja,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you
Hi @rooftopurja,
Have you had a chance to review the solution we shared by @rohit1991? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi @rooftopurja ,
there is a way to get dynamic period navigation (like left/right arrow buttons) in Power BI, but there are some important details to know:
1. Use Field Parameters for Flexible Period Switching The most robust method is to set up a Field Parameter with your period options (Day, Week, Month, Year, Lifetime, Custom, etc.). Add the field parameter slicer to your report.For left/right navigation, you can use arrow-shaped buttons that select the next or previous item in your parameter list using bookmarks or, for a smoother feel, sync the parameter slicer with your navigation buttons.
2. Bookmarks for Tab-like Navigation You can set up bookmarks for each period and link your arrow buttons to these bookmarks. This works well if you only have a few period options, but can get messy if you have a lot.
3. Limitations to Know Right now, Power BI doesn't support directly changing a slicer value with a button click like Excel does.The field parameter + button approach is the closest native workaround.
4. Pro Tips Make sure your line and column charts use the field parameter as the X axis so they update dynamically when the user changes the period. You can combine the period slicer and left/right navigation buttons for a seamless user experience.
5. Bonus: Power Apps Visual (for advanced scenarios) If you want true arrow button control (incrementing/decrementing the period), you can embed a Power Apps visual that changes the slicer value when you click an arrow. It’s a bit more setup but works well for advanced dashboards.
i spent a lot of time creating bookmarks with left and right arrow buttons - but it works for a single increment/ decrement. When we want to unlimited increment/decrement - like if the user wants to see line chart on 22nd march2023 - achieving the same with bookmark and buttons is a tedious task. I was unaware of the Power APPs visual - but have been trying since i got this message - Instead of Field Parameter - i created a TimeSlicer with a Period Table which can be seen in the 1st image - opened the power app visual in power bi desktop - added DateCardDisplay(used for realtime date) in data field of power app visual - i could create the following expressions but the text expression is failing for the DateCardDisplay -
Without images it is impossible to answer