Please note javascript is required for full website functionality.

Power BI Tips Blog Series

Power BI Tips Blog Series

Here is a complete list and respective links to all of our Power BI blogs

  1. Introduction to Power BI
  2. Excel vs. Power BI – when to use which?
  3. When should we use Power BI and when should we use Excel?
  4. Which Power BI should I use?
  5. Get Data – Connecting to Different Data Sources
  6. Excel-sior - Part 1
  7. Excel-sior Part 2
  8. Excel-sior Part 3
  9. Text isn't Limiting! - Part 1
  10. Text isn't Limiting! - Part 2
  11. Text isn't Limiting! - Part 3
  12. Text isn't Limiting! - Part 4
  13. Text isn't Limiting! - Part 5
  14. Xenagogue to Markup Lists - Part 1
  15. Xenagogue to Markup Lists - Part 2
  16. Xenagogue to Markup Lists - Part 3
  17. Just Speculate Over Numbers - Part 1
  18. Just Speculate Over Numbers - Part 2
  19. Just Speculate Over Numbers - Part 3
  20. Just Speculate Over Numbers - Part 4
  21. Just Speculate Over Numbers – Part 5
  22. Just Speculate Over Numbers – Part 6
  23. Just Speculate Over Numbers - Part 7
  24. Just Speculate Over Numbers – Part 8
  25. Top 5 Things in Power Bi That You Probably Aren’t Using (and Really Want to Use!)
  26. Access-ible Data - Part 1
  27. Access-ible Data - Part 2
  28. SumProduct in Seattle!
  29. Access-ible Data - Part 3
  30. Upgraded Quick Insights
  31. Quality of Life Improvements
  32. Quality of Life Improvements 2
  33. Conditional Formatting Improvements
  34. URLs in Measures
  35. Tooltip Reports
  36. Q&A Power BI Desktop
  37. Q&A Row Level Security
  38. M Intellisense
  39. Visting Ideas
  40. Visiting Ideas 2 – DAX editor
  41. Visiting Ideas 3 – Custom Visuals template
  42. Visiting Ideas 4 – Dynamic date slicer
  43. Using OneDrive and Setting Up Automatic Updates
  44. Using OneDrive and Setting Up Automatic Updates – Part 2
  45. Data Profiling
  46. Using OneDrive and Setting up Automatic Updates - .xls Files
  47. Power BI Gateway
  48. Get Data from PDFs
  49. New Course Development
  50. Row Level Security
  51. Keyboard Shortcuts
  52. Microsoft Ignite | The Tour Singapore
  53. Microsoft Teams
  54. Excel Publish to Power BI
  55. Custom URLs in Table Visualisations
  56. Publishing to Teams
  57. Key Influencers
  58. Key Influencers Top Segments
  59. Practical Influences
  60. Custom Visuals – Box and Whisker Chart
  61. Custom Visuals - Histograms
  62. Custom Visuals – Summary Table
  63. Custom Visuals – Infographic Designer
  64. New Model Tab
  65. New Highlighting and Filtering Icons
  66. Data Profiling Generally Available
  67. Key Influencers - Continuous Variables
  68. Get Data from Exchange
  69. Waterfall Charts
  70. New Web Table from Inference
  71. Restaurant Selector
  72. Performance Analyzer
  73. Key Influencers Binning
  74. Microsoft Business Applications Summit 2019
  75. June 2019 Update New Interface
  76. Waffle Chart
  77. Waffle Chart (cont'd)
  78. Mekko Chart
  79. Mekko Chart (cont'd)
  80. Floor Plan
  81. Excel Summit South 2019
  82. New Filters Pane
  83. New Transform - Split Column by Positions
  84. Real-time Forms to Dashboard
  85. Power KPI
  86. Copy vs. Export Data from Power BI Desktop
  87. Sankey Chart
  88. Colour Formatting Tips
  89. Colour Formatting Tips – Conditional Formatting for Column Charts
  90. Colour Formatting Tips – Conditional Formatting for Tables
  91. New Default Themes for Power BI Desktop
  92. Dynamic Headings Based on Slicer Selection
  93. Dynamic Images Based on Slicer Selection
  94. Sydney’s Register of Food Penalty Notices
  95. Sydney’s Register of Food Penalty Notices – Part 2
  96. Sydney’s Register of Food Penalty - Part 3
  97. Sydney’s Register of Food Penalty Notices – Part 4
  98. Sydney’s Register of Food Penalty Notices – Part 5
  99. New Web Table Inference (Black Friday Special)
  100. Sydney’s Register of Food Penalty Notices – Part 6
  101. Creating a Dynamic Calendar Table
  102. Presenting Several Measures on a Single Visualisation
  103. Dynamic Visualisation Titles
  104. Combo Charts
  105. Bullet Charts
  106. Creating Tables in Power BI
  107. Creating Summary Tables in Power BI
  108. Custom Visuals – the Hierarchy Tree
  109. Custom Visuals – the Hierarchy Tree Continued
  110. Custom Visuals – the Hierarchy Tree Advanced Editor
  111. Impact Bubble Chart
  112. Power BI Report Builder – Part 1 (Importing Data)
  113. Power BI Report Builder – Part 2
  114. Power BI Report Builder – Part 3 (Editing Print Layouts)
  115. Power BI Report Builder – Part 4 (Creating Charts)
  116. Power BI Report Builder – Part 5
  117. Power BI Report Builder – Part 6 (Using Parameters)
  118. Power BI Report Builder – Part 7 (Built-in Fields)
  119. Dark Themes
  120. Gauge Charts
  121. Personalize Visuals (Preview)
  122. Hierarchical Filters
  123. Custom Visualizations – Funnel/Pyramid Chart
  124. Custom Visualizations; Funnel/Pyramid Chart Formatting
  125. Conditionally Formatting Negative Numbers
  126. Conditionally Formatting from Text
  127. Conditionally Formatting Brackets with Negatives
  128. Dual Axis Line Chart
  129. The COALESCE Function
  130. Custom Button Page Navigation
  131. Dynamic Page Selector Navigation
  132. {Missing Field or Column Breaking Query}, No Problem!
  133. Importing Fonts into Power BI
  134. Rampant Column Widths
  135. Summarising the Top Two Countries in a Dataset
  136. Renaming Fields in a Custom Hierarchy
  137. Creating Custom Hierarchies
  138. Summarising the Top N Number of Cities in a Dataset
  139. Displaying Multiple Slicer Selections on Cards
  140. Calculating Cumulative Totals for Time Periods
  141. Ordering Slicer Selections on Cards
  142. Dealing with Overflow on Cards
  143. Introducing ISFILTERED
  144. Revisiting Formatting Negative Numbers with Brackets
  145. Dynamically Calculating Cumulative Metrics with the ALLSELECTED Function
  146. Text Data Groups
  147. Group Type – Bin (Grouping Numerical Values in Power BI)
  148. Analysing our Bins
  149. Extending Report Page Size
  150. Managing Slicers
  151. Setting Up Custom ToolTips
  152. Using Display Folders
  153. Canvas Watermarks
  154. Anomaly Detection
  155. New Year, New Icons
  156. Zoom Sliders
  157. Power BI on Teams
  158. Bulk Measure Format Reassignment
  159. Custom Field Formatting
  160. Easier Dynamic Heading Based on Time Slicer
  161. Dynamic Headings for In-Between Variables
  162. Different Coloured Columns in a Chart
  163. Different Coloured Columns in a Stacked Column Chart
  164. Dealing with an Excessive Number of Categories
  165. Ordered Legends
  166. Introducing the Decomposition Tree Visualisation
  167. More on the Decomposition Tree Visualisation
  168. Even More on the Decomposition Tree Visualisation
  169. Maximum and Minimum Levels on a Line Chart
  170. Maximum and Minimum Points on a Line Chart
  171. Revisiting Built-In Gauge Charts
  172. Gauge Visualisation – Presenting Percentages
  173. Calculating Monthly % Change
  174. Calculating Monthly % Change Update
  175. Share and Collaborate in Excel for the web Connected to Power BI
  176. Smart Narratives Now Generally Available
  177. Monthly New Customers
  178. Dynamic Headers
  179. CALENDAR tables
  180. Q&A Improvements for Inferred Results
  181. Select All Operation Now Supported for Dynamic M Query Parameters
  182. Draw a Line
  183. Leave a Line
  184. Access-ible Returns Part 1
  185. Access-ible Returns Part 2
  186. Access-ible Returns Part 3
  187. Power BI Desktop Installer Changes and WebView2
  188. Power Automate Visual Preview
  189. Sharing Q&A Synonyms
  190. New Way of Expressing Date and DateTime Values
  191. Power BI REST API Support for DAX Queries
  192. Data Formatting
  193. “X” and “Non-X” functions in DAX
  194. New Formatting Options for Buttons
  195. Insights Now in Preview in Power BI
  196. All in Order
  197. Conference Planning Part 1
  198. Conference Planning Part 2
  199. Dating Part 1
  200. Dating Part 2
  201. Dating Part 3
  202. New Format Pane
  203. New Page and Bookmark Navigators
  204. Pie and Donut Chart Rotation
  205. Scorecards and Power BI Goals
  206. QR Codes with URL Parameters for Power BI Mobile
  207. Sparklines in Preview
  208. Improvements to Power BI Mobile
  209. Hybrid Tables in Power BI Premium
  210. Dating Part 4
  211. Dating Part 5
  212. Dating Part 6
  213. Roles with no Insight
  214. New Format Pane, Still in Preview, Now on by Default
  215. Parameter Typo
  216. Power BI Goals Updated
  217. Fully Imported
  218. Refreshing to Change
  219. Not Imported
  220. Dynamic Format Strings Now Supported for All Chart Elements
  221. Error Bars in Preview
  222. Power BI Goals – Custom Statuses and Team Notifications
  223. More Updates for the New Format Pane
  224. Bookmark Navigator
  225. Push Notifications on Mobile Applications
  226. Locating Links
  227. Power BI Known Issues Page
  228. Canvas Zoom
  229. Field Parameters
  230. Data Point Rectangle Select
  231. Exportable Formatted Data Tables in Power BI Service
  232. Power BI Metrics
  233. Data Hub
  234. Datamarts
  235. Recent Improvements to the Power BI Experience in Excel
  236. New DAX Function - NETWORKDAYS
  237. Metric Visuals Updated
  238. Composite Models and Dynamic M Query Parameters Part 1
  239. Composite Models and Dynamic M Query Parameters Part 2
  240. Composite Models and Dynamic M Query Parameters Part 3
  241. More on Datamarts
  242. Field Parameters – Part 1
  243. Field Parameters – Part 2
  244. Field Parameters – Part 3
  245. Field Parameters – Part 4
  246. Auto-Generate Reports on Existing Datasets in Power BI Service
  247. Display Names for Summarized Fields
  248. Hierarchical Axis (by default)
  249. Quick Measure Suggestions (an Experimental Feature)
  250. Row-Level Security (RLS) – Part 1
  251. Row-Level Security (RLS) – Part 2
  252. Row-Level Security (RLS) – Part 3
  253. Datamarts – Part 1

Newsletter