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!

Essential Power BI Reports for Senior Living Operators
Well-crafted Power BI reports can help senior living operators turn disparate data into coherent and actionable insights.
ur senior living operation and reap serious efficiency gains, we’ve assembled a list of Power BI reports that consistently deliver the most value. Read on to learn more!