Power BI Weekly

This is a weekly series covering interesting and useful topics in Power BI.

New This Week

• DAX INFO functions with the DAX query editor

Introduction

• Unlocking techniques with Power BI
• What you should know

1. Power BI Weekly Series (April

• Converting local time to UTC time
• Running R script on existing query
• Running Python script on existing query
• Calculating score sentiment with Text Analytics functions
• Integrating Python scripts into visuals
• Adding a button for resetting filters
• Layering visual elements on a page
• Selecting columns dynamically in a matrix visual
• Changing displayed axes dynamically
• Changing visual titles dynamically
• Configuring condition color options
• Drilling through pages
• Switching between two visuals in one space

2. Power BI Weekly Series (July

• Clustering values in Dataflows
• Merging tables with fuzzy matching
• Creating custom maps
• Adding error bars to a visual
• Building calendar heat maps
• Adding play button for time series fields
• Combining single-card visuals
• Configuring dynamic constant lines
• Combining text labels with CONCATENATEX
• Building a Pareto chart
• Utilizing SWITCH
• Highlighting selected data
• Calculating durations dynamically

3. Power BI Weekly Series (October

• Connecting to data with a Python script
• USERELATIONSHIP DAX filter function
• Images as data
• DAX operators
• Sparklines on table and matrix visuals
• Dynamic axes start and end values
• Field parameters
• Smart narrative visual
• Power BI REST API developer sandbox
• Deneb visual
• Performance analyzer
• XMLA endpoint
• Power BI goals

4. Power BI Weekly Series (January

• DAX queries for import data
• Row-level security
• Clipped shapefile maps
• Conditional formatting for data bars, icons, and web URLs
• Report filter resets for only selected visuals
• NETWORKDAYS DAX function
• Date calculations with alternative year-end dates
• Non-standard calendar DAX calculations
• Aggregated slicers using measure value inputs
• TOPN DAX function
• Normal distribution curve in DAX measures
• PRODUCTX DAX measure
• Logarithmic visual scales

5. Power BI Weekly Series (April

• Using OFFSET to change DAX measure context
• Creating Gantt charts
• Creating a star review DAX measure
• Adding budget lines to bar charts with actuals
• Using INDEX to access a value position
• Creating correlation plot matrix
• Using SWITCH with multiple conditions
• Converting scatter plots into 2D and hexbin heat maps
• Running linear regression with LINEST DAX function
• Building a pairplot visual for multiple scatter plots
• Expanding row filter context in DAX measures with WINDOW function
• Updating Power BI visuals with modern tooltips
• Adding a shape map outline as a style with Mapbox custom visual

6. Power BI Weekly Series (July

• Dynamic measure formatting
• Apply and clear all slicers
• AI for DAX measures
• Text data labels
• On-object visual editing
• Pop-out slicer pane
• Hex color value formatting
• Conditional data label font colors
• Sales from new customers
• Field parameter groups
• Custom gridlines
• Radar charts
• Visio diagrams

7. Power BI Weekly Series (October

• Create paginated reports in Fabric
• Leverage Power BI Report Builder
• Add paginated report visual to Power BI report
• Create logistic regression visual
• Add local midnight markers
• Label data points with DAX measures
• Use new card visual
• Interpolate values
• Build DAX date table
• Add leader lines
• Highlight a line in a visual
• Query Power BI REST API
• Change matrix visual orientation

8. Power BI Weekly Series (January

• Pattern matching in Power Query
• ArcGIS map visual
• Heatmap map layer
• 3D columns map layer
• Adding subtitles to titles
• Help header icons with tooltips
• Relative date slicer options
• Markers and labels for latest data point
• Mapbox visual with layers
• Series label options
• Shaded areas with reference lines
• Calendar values on new card visual
• Calendar titles on new card visual

9. Power BI Weekly Series (April

• Formatting labels in the new card visual
• Formatting values in the new card visual
• Adding background card colors in the new card visual
• Adding borders to the new card visual
• Adding images to the new card visual
• Integrating Power Apps into Power BI
• Using the DAX ISFILTERED function
• Building tessellated maps
• Leveraging Azure Maps clustering
• Leveraging the new slicer visual
• Adding customized data labels
• Customizing the appearance of bars
• Sorting column order in Power Query

10. Power BI Weekly Series (July

• Stream graphs
• Azure Maps reference layer
• Calculation groups with the DAX SELECTEDMEASURE function
• Using the SELECTEDMEASURENAME DAX function