Bits and pieces from the world of Business Intelligence by Belinda Allen

You cannot improve what you do not measure.

Skip to content
  • Home
  • About
Search

Month: May 2019

Creating a Conditional Title with DAX in Microsoft Power BI

May 31, 2019May 28, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

Continue reading →

Tips on using the Matrix Visual in Microsoft Power BI

May 29, 2019May 28, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.  I’ll build a GL Account Summary Matrix by month.

Continue reading →

Using Divide in a DAX Measures in Microsoft Power BI

May 28, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Today’s DAX Expression:

Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)

Continue reading →

Treemap Bar Chart in Microsoft Power BI

May 24, 2019 / Belinda Allen / Leave a comment

In this video, I’ll use a new custom visual called the Treemap Bar Chart.  It’s like the baby of the Clustered Column Visual and the Treemap Visual.  This was created by MAQ Software. https://maqsoftware.com/

Continue reading →

Line Chart Formatting in Microsoft Power BI

May 22, 2019May 20, 2019 / Belinda Allen / Leave a comment

 In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.

Continue reading →

Creating DAX Measures in Microsoft Power BI

May 20, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading →

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

May 17, 2019May 13, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

Continue reading →

Adding the Q&A Visual in Microsoft Power BI

May 15, 2019May 13, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

Continue reading →

Creating DAX Columns in Microsoft Power BI

May 13, 2019 / Belinda Allen / Leave a comment

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading →

Did I help?

Buy Me a Coffee

Recent Posts

  • Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
  • Show Value for the Last Date in Microsoft Power BI
  • More Matrix (visual) formatting in Microsoft Power BI
  • Using Small Multiples in Microsoft Power BI
  • Matrix (visual) totals and subtotals in Microsoft Power BI

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 2,713 other subscribers

Recent Comments

Show Value for the L… on Show Value for the Last Date i…
More Matrix (visual)… on More Matrix (visual) formattin…
Using Small Multiple… on Using Small Multiples in Micro…
Matrix (visual) tota… on Matrix (visual) totals and sub…
Using an Inserted Sh… on Using an Inserted Shape as a N…

Archives

  • January 2022
  • July 2021
  • May 2021
  • April 2021
  • October 2020
  • September 2020
  • August 2020
  • August 2019
  • June 2019
  • May 2019
  • December 2018
  • November 2018
  • April 2018
  • May 2017
  • December 2016
  • June 2016

Categories

  • AI
  • Business Central
  • Data
  • Dates
  • DAX
  • Excel
  • Filters
  • Financials
  • Formatting
  • General
  • MBS Podcast
  • Microsoft Power BI
  • Navigation
  • Parameters
  • Power Apps
  • Q&A
  • Refresh
  • Teams
  • Tiny tips – Power BI
  • Tooltips
  • Visuals
  • Webinars

Social

  • View @MsBelindaAllen’s profile on Twitter

MBS Podcast

Recent Posts

  • Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
  • Show Value for the Last Date in Microsoft Power BI
  • More Matrix (visual) formatting in Microsoft Power BI
  • Using Small Multiples in Microsoft Power BI
  • Matrix (visual) totals and subtotals in Microsoft Power BI

Recent Comments

Show Value for the L… on Show Value for the Last Date i…
More Matrix (visual)… on More Matrix (visual) formattin…
Using Small Multiple… on Using Small Multiples in Micro…
Matrix (visual) tota… on Matrix (visual) totals and sub…
Using an Inserted Sh… on Using an Inserted Shape as a N…

Archives

  • January 2022
  • July 2021
  • May 2021
  • April 2021
  • October 2020
  • September 2020
  • August 2020
  • August 2019
  • June 2019
  • May 2019
  • December 2018
  • November 2018
  • April 2018
  • May 2017
  • December 2016
  • June 2016

Categories

  • AI
  • Business Central
  • Data
  • Dates
  • DAX
  • Excel
  • Filters
  • Financials
  • Formatting
  • General
  • MBS Podcast
  • Microsoft Power BI
  • Navigation
  • Parameters
  • Power Apps
  • Q&A
  • Refresh
  • Teams
  • Tiny tips – Power BI
  • Tooltips
  • Visuals
  • Webinars

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Powered by WordPress.com.
 

Loading Comments...