Tag: Date Slicer

Dynamic Date Slicer In Power BI Using A Period Table

Dynamic-Date-Slicer-In-Power-BI-Using-A-Period-Table

In today’s blog post, I’d like to discuss what we like to call the period table. The period table creates a distinct date range so you can slice your data any way you want. I’ll show you how you can create a dynamic date slicer in Power BI by using this period table. You may

Continue reading

Compare Data Points From Different Timeframes In One Visualization – Power BI

Compare Data Points From Different Timeframes In One Visualization - Power BI

In this blog I’ll show you how you can compare data from different timeframes within the same visualization. You can get amazing Power BI insights using this great technique with time-related DAX. You may watch the full video of this tutorial at the bottom of this blog. I discovered this approach from the Enterprise DNA

Continue reading

How To Date Harvest In Power BI Using DAX

In this tutorial, we’ll go through date harvesting in Power BI to get information from a date slicer for a time intelligence analysis. You may watch the full video of this tutorial at the bottom of this blog. From previous tutorials, we’ve learned how to extend our date table while integrating a holiday table to

Continue reading

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this blog post, you’ll learn how to show data from specific time frames as filtered by a date slicer without affecting the overall Cumulative Totals. This is based on a query on the Enterprise DNA Members-Only Support Forum. For sure, you’ll find this quite useful when facing a scenario similar to the example that

Continue reading