Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this tutorial I run through a unique example that recently came up on the Enterprise DNA Support Forum.

This example looks to solve how to showcase cumulative total comparisons, but to only have one part of the visualization affected by a slicer selection on dates.

This is relevant if you wanted to showcase information or values versus forecasts but you wanted to be able to adjust the date range you are looking at for your actual values and leave your forecasts as they are.

We look to use a duplicate date table to solve for this scenario.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.