Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Columns

Power BI – Dynamic Axis

Power BI – Dynamic Axis

Posted on February 17, 2020February 17, 20205 Comments on Power BI – Dynamic Axis

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. There are a few ways this can get solved, such as using bookmarks. For this … Continue reading Power BI – Dynamic Axis

Overriding slicers

Overriding slicers

Posted on February 5, 2020February 5, 202012 Comments on Overriding slicers

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter), how can I show data for other items a visual that may be related by my selection. An example of this … Continue reading Overriding slicers

Dynamic Columns based on values

Dynamic Columns based on values

Posted on January 28, 2020January 28, 202020 Comments on Dynamic Columns based on values

I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots of blogs showing different techniques on dynamic columns, but the requirement here was to base the decision on whether to show … Continue reading Dynamic Columns based on values

Mixed Grain aggregations

Mixed Grain aggregations

Posted on November 18, 2019No Comments on Mixed Grain aggregations

My last article described the Shadow Model data modelling technique and how you can use it to help resolve a specific performance challenge caused by tables forced to direct query mode in particular scenarios. The approach detailed in that article used the GROUP BY method of mapping “alternate of” columns which can result in unwanted … Continue reading Mixed Grain aggregations

Posts navigation

Previous page Page 1 Page 2 Page 3 Next page

Search

Categories

  • Advanced
  • Aggregations
  • Analysis Services
  • Blog
  • Calculation Groups
  • Columns
  • Composite Models
  • Data Modelling
  • DAX
  • Direct Query
  • Distinct Count
  • Easy
  • Fabric Notebook
  • Filtering
  • Inventory
  • Medium
  • Optimise
  • Performance
  • Power BI
  • Power BI Refresh
  • PowerShell
  • Relationships
  • Semantic-link
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • Create charts using Vega in Microsoft Fabric Notebook
  • Visualize Power BI Refresh using Semantic-link
  • DAX Pareto Calculation
  • Speed up Distinct Count calculations in Power BI using Aggregations
  • Using PowerShell to create Calculation Groups in Power BI Desktop
Phil Seamark on DAX

Back to top
 

Loading Comments...