-
Implementing Proper and Optimized Pagination
This article details a pagination technique for Power BI visuals, using field parameters and DAX measures to eliminate scrolling. Building upon Bas Dohmen’s work, this enhanced version improves loading times through optimized DAX measures for item filtering, resolves duplicate ranking issues with a secondary sorting criterion, and addresses skipped ranks with additional DAX functions. Problem…
-
Visualizing MoM Change with the Piano Chart
This article provides a step-by-step guide to replicating the “Piano” or “Delta” chart, a creative visualization for showing changes between two points in time, within Power BI. This chart, originally created in Tableau by Guido Jongbloed, is particularly effective for emphasizing percentage changes between months. Limitations Several DAX workarounds are necessary to improve the visualization’s…
-
Highlighting Specific Values in a Line/Area Chart
Key values (first, last, minimum, and maximum) are highlighted in a line chart using data labels and error bars to identify periods of missing data throughout the years.
-
Visualizing Monthly KPIs Using the JFMAMJJASOND Calendar Format
This article guides you through creating visually-appealing monthly metrics reports in Power BI by converting month names to abbreviations for a cleaner look. Foreword Dashboard design requires careful consideration of visual elements. For example, text length can significantly impact the size and layout of visuals, potentially requiring additional space and reducing valuable white space. One…
-
Creating Dynamic Slope Graph with % YoY Label
Constructed using two DAX measures and an additional measure for conditional formatting, this dynamic slope graph responds to slicer selections.
Incorporating data storytelling into Power BI Core Visuals 