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
Tips for More Accessible Presentations
I’m busy building presentations for some upcoming conferences, so in lieu of a full blog post, please read my twitter thread about making your presentations more accessible. All but one of these tips are applicable regardless of the software that you use to build presentation content. Why lose the engagement of a single person in… Continue reading Tips for More Accessible Presentations