Tag: SWITCH True Logic

DAX Optimization: Where To Find The Hidden DAX Trap

I want to focus today on something I call the hidden DAX trap. If you encounter this situation, it will make you feel like you’re losing your mind because your DAX is going to look right, but it’s not going to work. I’ll walk you through when that occurs and what you can do about

Continue reading

Power BI Financial Dashboard: Complete Table Customization Tips

Power BI Financial Dashboard: Complete Table Customization Tips

For today, I’ll talk about financial reporting. I want to show you how to create customized tables for your Power BI financial dashboard report. The ability to customize your tables inside of Power BI will give you immense flexibility when creating reporting applications. In this particular example, we’re talking about financial reporting, but this technique

Continue reading

Power BI Matrix | How To Fix Matrix Totals In Power BI

Power BI Matrix | How To Fix Matrix Totals In Power BI

For this tutorial, I’m going to show you how to fix Power BI matrix totals, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. You may watch the full video of this tutorial at the bottom of this blog. There are two reasons why I wanted to address

Continue reading

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

Create A Multilingual Power BI Report

Create A Multilingual Power BI Report

For today’s blog, I want to discuss a not-unusual situation with many of my consulting assignments for the Canadian government, where my clients require all publications to be bilingual or available in both official languages, English and French. I’ll show you how I do a multilingual Power BI report for this tutorial. You can watch

Continue reading