Power BI Weekly
Issue #298 - 4th March 2025
Just one official announcement this week - there are only two weeks left to submit your entry for the Power BI DataViz World Championships, with a chance to compete at the grand finale, live in Las Vegas at the Fabric Community Conference.
Elsewhere this week, Chandeep Chhabra explores how to replicate common Excel calculations in Power BI using both visual calculations and DAX. The Learning Science channel showcases examples of the new preview feature: conditional formatting support for visual calculations. Finally, Bernat Agulló Roselló has continued his series on Making a Report Bilingual: The Full Story (Part 2).
🛠️ Data Prep
- On the Data Bear blog, Boniface Muchendu (@DataBearLTD) blogs about Understanding the Include in Refresh Feature in Power Query
- Rick de Groot (@Rickmaurinus) explains How to Return a Data Type as Text in Power Query M (Step-by-step Guide)
🧩 Data Modeling
- On the Data Bear blog, Boniface Muchendu (@DataBearLTD) explains how to Migrate Your Power BI Semantic Models to Direct Lake and explains How to Add a Calculated Column to Power BI Direct Lake Models
- Also on the SQLBI blog, Marco Russo (@marcorus) blogs about Account receivable aging in Power BI
- Chandeep Chhabra (@chandeep2786) talks about Excel Users Struggle with These Calculations in Power BI – Here’s the Fix
- Justin Martin (@dax_noob_justin) covers Fabric Tools: DAX Performance Testing
- On the Power BI community blog, Kumail Raza writes about Understanding TMDL in Power BI: A Game-Changer for Data Modeling
📊 Report Authoring and Interactivity
- On the Power BI blog, Shannon Lindsay (@MSPowerBI) announces Power BI DataViz World Championships | 2 Weeks Left to Compete
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes How to Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title in Microsoft Power BI and talks about Visual to Show Both Values & Percent | Data Labels | Column or Bar Chart
- Valerie Junk (@porcubi) describes Using Error Bars to Visualize Targets in Power BI and writes about Conditional Formatting Button in Power BI
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) blogs about Power BI Visual Calculation Magic - Conditional Formatting
- Sarah Gendron (@lecfomasque) covers Maximisez l’interactivité de vos rapports Power BI avec les visuels Questions et réponses (Q&A) [French]
🚀 Deployment, Security and Operations
- On the Power BI community blog, Vivienne Vereen describes Fabric Capacity Scaling and Power BI - What happens when Power BI model guardrails are exceeded?
- Stephanie Bruno (@StephTBruno) presents Ep. 7 - Semantic Link and Semantic Link Labs
- Philipp Lenz (@lenz_philipp) writes about Error when using a Power BI Embedded app via the Power BI Embedded Onboarding Tool
🌐 General
- Bernat Agulló Roselló (@AgulloBernat) covers Making a Report Bilingual: The Full Story (Part 2)
- On the Data Bear blog, Boniface Muchendu (@DataBearLTD) blogs about February 2025 Power BI Update: Monitoring Hub, Copilot, Visual Calculations