In this post I’m going to show one of my favourite financial modeling tricks: how to use Aggregate to Count Visible Rows. Background Often, when I’m building models in Excel, I like to group key assumptions at the top of
One of the most important questions we have when publishing our data models and Power BI reports is Can users see my raw data? The answer to this should virtually always be no unless you’ve explicitly stated you want this
Getting the Most From Excelguru Forums We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question. How the Forum Works Using the Forum Step 1 –
This week I was playing around with MailChimp and Power BI. If you’re not familiar with MailChimp, it’s the service that we use to send out our Monthly-ish newsletter. I thought I’d show how incredibly easy it is to get
For those coming from the Excel 2013 world, you’ll surely want to create filters using the Power BI Slicers. After all, you know that Slicers and Timelines are two of the sexiest filters we have for controlling filter context in
Have you ever set up a nice query to UnPivot other columns, only to find that the query data types change when you add new columns? This post will cover why values become text after unpivoting other columns. Background We’ve
This is the fifth and final installment of this post series, and will demonstrate the process for publishing and sharing Power BI Dashboards (as compared to Reports.) Key things we’ll explore here are the additional benefits of Power BI Dashboards
This is the fourth installment of this post series, and will demonstrate the process for publishing and sharing Power BI Reports. Key things we’ll look at here are how to publish the dashboard, keep it up to date, and share
In this post I’m going to continue the process of creating a Power BI dashboard built off the data I sourced from OneDrive for Business. This time I’m going to look specifically at creating Power BI Card Visuals. Series Table
Last week I grabbed some data from OneDrive for Business. This week I’m going to start the process of creating Power BI visuals to build a dashboard which will be hosted in the cloud. Series Table of Contents This is
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
