Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/site/wwwroot/wp-content/plugins/feedwordpress/feedwordpress.php on line 2106
Data-driven vs. Data-informed: Let’s Acknowledge the Truth
This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through or need alt text: Person 1: We need to be data-informed, not data-driven.Person 2: What’s the difference?Person 1: It’s a loophole that allows decisions based upon… Continue reading Data-driven vs. Data-informed: Let’s Acknowledge the Truth
Use a slicer to filter a visual based upon a measure in Power BI
Have you ever wanted to filter a visual by selecting a range of values for a measure? You may have found that you cannot populate a slicer with a measure. But you can do this another way. I have a report that shows project expenses and budgets. I want users to be able to filter… Continue reading Use a slicer to filter a visual based upon a measure in Power BI
Power Query ODBC bug affecting date calculations
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks Unity Catalog. I didn’t have access to add more fields to the view, so I was adding the fields in Power Query first, with plans to… Continue reading Power Query ODBC bug affecting date calculations
Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient colors (maybe you just used the default colors), you will end up with poor color contrast. Luckily there are a couple of quick (less than 30… Continue reading Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them