DaxLib.FormatString Documentation
A library of DAX User-Defined Functions for creating dynamic and custom format strings for semantic models in Power BI.
Note: This site was created with agentic coding tools as an experiment. This is a small open source project testing the application of coding agents in certain DAX and lifecycle management-related tasks.
Dynamic Formatting
Automatically scale numbers with K/M/B/T suffixes and handle currency formatting with international support.
Relative Comparisons
Create format strings with directional indicators (arrows, triangles) for comparison scenarios.
Time Duration
Convert time durations between dates or from seconds into HH:MM:SS format strings.
Component Utilities
Modular building blocks for creating custom format string solutions with reusable components.
Basic Standards
Standardize date, time, number, and percentage formatting across your entire data model.
Currency Support
support for 50+ international currencies with proper symbol positioning.
Getting Started
Select a function from the sidebar to view detailed documentation, syntax examples, and usage patterns.
Functions are organized by category to help you find the right tool for your formatting needs:
- Basic Functions: Standardized formatting for common scenarios
- Main Formatting: Advanced dynamic formatting with automatic scaling
- Relative Comparisons: Visual indicators for data comparisons
- Time Formatting: Duration and time-based format strings
- Component Utilities: Building blocks for custom solutions