This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want to start a 24 month look back in. Users love 12 or 24 month graphs that let them see history. But sometimes they want to choose the month they start their look-back from. Here’s how you do that with DAX and Disconnected Slicers. Credit goes to Brian Grant for the solution with a few modifications made by the rest of us along the way!

Power Automate AI Builder
Power Automates’ artificial intelligence (AI) can enhance your workflows by bringing intelligent automation to your business processes.