Report Data Tips Archives -

News Ticker

[ 2024-07-30 ] Overcoming Challenges in the Center of Excellence Articles & Opinions
[ 2024-07-26 ] Exploring the Power of Semantic Link PowerBI.Tips Tools
[ 2024-04-29 ] Tips+ Designer and Theme Generator Tutorial: Automatic Visual Objects with AI Learn Designs
[ 2024-02-27 ] Tips+ Designer and Theme Generator Tutorial: Gallery Project Copy & Edit Learn Designs
[ 2024-01-29 ] Tips+ Designer and Theme Generator Tutorial: Gallery Project Download for Easy Theme Solutions Learn Designs

Milwaukee Brew City PUG – June 2020

2020-07-01 Mike Carlo

This month’s Milwaukee Power BI User group we have Reza Rad from Radacad.com. Reza has a long history within the Power BI MVP community. His presentation this month is about how to use dataflows and […]

Data Table Filters

2018-06-06 Mike Carlo

Hands down best feature this year to date, Data Table Filtering! In the June 2018 Power BI Desktop Microsoft released the ability for you to navigate to the Data Table view. While on this view […]

Start of Month DAX Calendar

2017-12-20 Mike Carlo

While on a recent project I needed to build a variation of the DAX date table. In my previous post, found here Creating DAX Date Tables I was built a date table for every day of the […]

Creating A DAX Calendar

2017-11-01 Mike Carlo

There are many cases when you will need to create a date table within Power BI desktop. This could be as simple as creating a master date table or more complex such as creating a […]

Ranking Values with Measures

2017-07-25 Mike Carlo

In many reports we produce we often need a method to score or rank data. For example, we may need to list the sales totals for the sales team and rank them from highest sales […]

Use Multiple Connections Between Tables

2017-07-05 Mike Carlo

For those of you who work in supply chain management this tutorial will be right up your alley. In my previous job position I had a lot of interaction with our shipping department. We would […]

UseRelationship DAX Tutorial – Curbal

2017-07-03 Mike Carlo

Here is another great tutorial from Curbal. This tutorial teaches you how to use the DAX function UserRelationship. This is important when your dealing with a tables in your data model that have multiple relationships. […]

Using Variables within DAX

2017-05-05 Mike Carlo

Every so often you find a hidden gem, something so valuable, just hiding there in plain sight. Recently, I found out that I LOVE the using Variables with in a DAX expression. Ok, brief introduction, I was […]

SUM & SUMX Tutorial – Curbal

2017-04-06 Mike Carlo

Learn how to use SUM() and SUMX() with this great video from Curbal. As you become more familiar with PowerBI you will increase your understanding of DAX (Database Analysis Expressions). Microsoft has an extensive list […]

Dynamic Filters in PowerBI

2017-04-05 Mike Carlo

This video talks about how to create custom links that apply report level filters. This is super cool and provides a ton of wide flexibility when building drill down reports. In this example Patrick talks to […]