This webinar discusses and demonstrates IronEdge’s advanced approach to date slicing in Power BI for improved functionality across report pages. With a clever use of the SWITCH statement, XTD slicing becomes a breeze with literally only the click of a button. You can expect to learn how to set up the data model calendar, this SWITCH statement, and the measures to proc the selector in the SWITCH statement for the specified time period. This presentation highlights the following:
- How to create and set up disconnected tables in your data model
- How to set up a dynamic measure selector
- Use cases
- Pros and cons to using this methodology
Additionally, you can use M to build out Time Slicers such as the example we provided in a previous blog post. Email us if you have further questions!
We provide both free and paid training engagements for teams of all sizes. If you would like more advanced training check out our training opportunities or partner with us for on-demand support.