goodly1

In this blog, I walk through some really useful Power BI visual design tips that can make your reports cleaner, more interactive, and much more insightful. We cover data bars using conditional formatting, custom tooltips in Power BI, report page tooltips, HTML card visuals, Claude with Power BI, dynamic format strings, and a smart way to make table and matrix visuals look a l...

If you have ever tried to use a measure in a slicer in Power BI, you already know it does not work directly. In this blog, I show you a practical workaround to use a measure in a slicer, build a dynamic slicer based on measure values, and then use that slicer to drive your DAX calculations. We start by understanding why a Power BI slicer only accepts a column from a physical ...

Your Power Query breaks mostly because there is too much hard coding inside the query. In this blog, I show you how to make your Power Query queries more robust and unbreakable by removing hard coding from common breaking points. We look at dynamic column expansion, combining nested tables, fixing the Change Type step, handling missing columns, and dealing with case sensitivi...