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

Data

Creating data source parameters for SQL Server in Microsoft Power BI

September 17, 2020 / Belinda Allen / 2 Comments

If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you.  In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.

Renaming and Hiding Fields in Microsoft Power BI

September 4, 2020September 2, 2020 / Belinda Allen / 1 Comment

Tiny Tips

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.

Today’s DAX Expression:

Customer and Class = 
Customers[Customer Name] & " " & Customers[Customer Class]

Setting Geographic Data Categories in Microsoft Power BI Q&A

August 31, 2020 / Belinda Allen / 1 Comment

Tiny Tips

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York.

Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)

August 5, 2020 / Belinda Allen / Leave a comment

Tiny Tips

by @MsBelindaAllen

 

In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data!

Posts navigation

Newer posts →
Did I help?

Buy Me a Coffee

Recent Posts

  • Add a prefix to a field in Microsoft Power BI via Power Query
  • Microsoft Power BI Story Telling with PowerPoint
  • Parameters for Excel File Path in Microsoft Power BI
  • Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
  • Show Value for the Last Date 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 5,809 other subscribers

Recent Comments

Microsoft Power BI S… on Microsoft Power BI Story Telli…
Parameters for Excel… on Parameters for Excel File Path…
Frank on Matrix (visual) totals and sub…
Microsoft Dynamics B… on Microsoft Dynamics Business Ce…
Show Value for the L… on Show Value for the Last Date i…

Archives

  • March 2023
  • 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
  • PowerPoint
  • Q&A
  • Refresh
  • Story Telling
  • Teams
  • Tiny tips – Power BI
  • Tooltips
  • Visuals
  • Webinars

Social

  • View @MsBelindaAllen’s profile on Twitter

MBS Podcast

Recent Posts

  • Add a prefix to a field in Microsoft Power BI via Power Query
  • Microsoft Power BI Story Telling with PowerPoint
  • Parameters for Excel File Path in Microsoft Power BI
  • Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
  • Show Value for the Last Date in Microsoft Power BI

Recent Comments

Microsoft Power BI S… on Microsoft Power BI Story Telli…
Parameters for Excel… on Parameters for Excel File Path…
Frank on Matrix (visual) totals and sub…
Microsoft Dynamics B… on Microsoft Dynamics Business Ce…
Show Value for the L… on Show Value for the Last Date i…

Archives

  • March 2023
  • 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
  • PowerPoint
  • Q&A
  • Refresh
  • Story Telling
  • Teams
  • Tiny tips – Power BI
  • Tooltips
  • Visuals
  • Webinars

Meta

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

Loading Comments...