Tag: Slicer Selection

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

Budget vs Actual vs Last Year – Financial Reporting Tips

Here, I’m eager to demonstrate how you can dynamically represent financial information in a compelling manner using Power BI. Now, it’s very easy to study budget vs actual vs last year inside Power BI because of its immense improvement in terms of financial reporting. With this advancement, you can readily evaluate performance and forecast future

Continue reading

See Changing Results Using Calculated Columns In Power BI

In this tutorial, I’m going to run through a number of great analytical techniques that you can combine and use within Power BI. For your organization, you may want to understand what’s happening or what is causing the underlying adjustments or changes to your data and results. I will show you in this tutorial some

Continue reading

Data Visualization with Power BI: How To Add Commentary to Your Reports in a Dynamic Way

This idea came up purely from a client requirement, and by implementing it I thought wow, this actually has many applications. It’s also not that difficult to implement in Power BI. I know this happens everywhere in organizations, so I’m sure you can relate, but have you ever created a PowerPoint presentation and then had

Continue reading

How To Harvest Power BI Slicer Selections To Use Within Other Measures

How To Harvest Power BI Slicer Selections To Use Within Other Measures

What I’m looking to achieved here is to showcase how you can create a table on the fly in Power BI, then place a column of that table into a slicer to then extract or ‘harvest’ a value inside a measure. Then be able to insert this into an existing calculation or another measure that

Continue reading