A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order.
Read more

Course calendar
video courses
  DAX Patterns collection
  Intro to Data Modeling Free
  Data Modeling for Power BI
  Power BI Dashboard Design
  Introducing DAX Free
  Mastering DAX 2
  Optimizing DAX
  SSAS Tabular
  Power Pivot
Classroom courses
Check out the latest updates on our training page.


The Static segmentation pattern classifies numeric values into ranges. The price ranges are stored in a configuration table and the pattern requires the model to be entirely data-driven. In other words, when the configuration table is updated, the model is updated automatically without requiring any change to the DAX code.
Read more


Latest videos

DAX Patterns


Latest news
• Chat with Marco Russo (podcast)
Lars Schreiber has invited Marco Russo to his podcast series. The result is a nearly two-hour not-very-technical interview covering SQLBI history, public speaking, teaching, consulting, challenges in IT careers, business intelligence trends, and much more.
Sep 6, 2020 · Marco Russo
• Power BI Premium per User license
Big news: Power BI Premium Gen2 will come with a choice of capacity or per-user license. Chris Finlan explains all the details, we just have to wait for an important thing: pricing. With the right price, this is a game-changer. The preview will be free and starts in November.
Sep 23, 2020 · Microsoft
• Power BI September 2020 release
Enhanced Dataset Metadata is now generally available and External Tools are much easier to use. Try the new smart narratives and many other improvements described in the announcement. Seriously, this is a mandatory upgrade, don't waste another minute.
Sep 22, 2020 · Microsoft
• Other Power BI announcements at Microsoft Ignite
Now that you have seen all the features in the September release of Power BI Desktop and you have planned the Premium features to use in November, you can see the other Power BI announcements Microsoft made at Ignite. Integration with Teams, Synapse, HoloLens, and much more coming up in the next few months.
Sep 23, 2020 · Microsoft
• Introducing the new Power BI Premium “Gen-2” architecture
The second generation of Power BI Premium presents many architectural differences compared to the current version. The new architecture enables per-user licensing, but there are also many improvements to the generic Capacity licensing. This short article is a good summary of these changes.
Sep 23, 2020 · John P White
• New Power BI experiences in Microsoft Teams
Read all the details about the integration between Power BI and Microsoft Teams. You can also watch many of these demos in the second half of the Deliver insights where decisions are made with Power BI session at Microsoft Ignite.
Sep 22, 2020 · Microsoft
• Check the quality of all Power BI data models at once with Best Practice Analyzer Automation (BPAA)
Dave Ruijter created Best Practice Analyzer, an automated solution that runs the Tabular Editor Best Practices Analyzer over all the data models published on Power BI and consolidates the result into a Power BI report. You need Power BI Premium because it requires XMLA endpoints.
Sep 12, 2020 · Dave Ruijter
• Power BI report performance and the number of visuals on a page
Chris Webb demonstrates why too many visuals in a report page can slow down your report, and how to measure this cost in the browser. Because sometime it's just an HTML problem...
Sep 20, 2020 · Chris Webb
• Design guide for Power BI slicers and filters
The first OKVIZ article about data visualization techniques in Power BI is a guide to slicers and filters in Power BI. David Eldersvaeld describes the tools available and when to use each one. A useful guide for new and experienced Power BI users.
Sep 21, 2020 · David Eldersveld
• Time for a new Power BI icon
We don't usually repeat the same image in two consecutive pieces of news related to the same topic. We made an exception in this newsletter because this could be the last time you see the Power BI logo you know so well. Microsoft is changing the Power BI icon. Click the title of this paragraph for a sneak peek, and for the result of the survey. You may be surprised by the new icon, or by the survey, or by both!
Sep 29, 2020 · Marco Russo