Tag: SWITCH True Logic

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 may watch

Continue reading

Dummy Variables: How To Use Them To Write Smarter DAX

Dummy Variables: How To Use Them To Write Smarter DAX

In this tutorial, I’ll be talking about how to use dummy variables in writing better DAX measures. This is especially applicable in cases where more complex DAX is needed. Using this technique, you can be more flexible in dealing with different variables and conditionals. You may watch the full video of this tutorial at the

Continue reading

Building Data Dimensions In Power BI

Build Other Data Dimensions in Power BI

In today’s blog post, I want to discuss how you can build additional data dimensions in Power BI. These dimensions can help you filter your data in different ways. On top of that, these dimensions can help you come up with intuitive visualizations later on. This is also the reason why you need to set

Continue reading

Power BI Dynamic Visuals Using SWITCH TRUE Logic – Visualization Technique

One of the most common concerns I see in the Enterprise DNA Support Forum relates to creating dynamic visuals. In this blog, I’ll focus my discussion on multi-measure Power BI dynamic visuals. I have a tutorial about this topic, which I’d like to highlight in this article.  The tutorial will show you how to work and present your results in a dynamic way and how you can change

Continue reading

How To Create Unique Subtotals In Power BI Tables

How To Create Unique Subtotals In Power BI Tables

In this tutorial, I’m going to show you how to create unique subtotals in your Power BI tables using the SWITCH TRUE logic. You may watch the full video of this tutorial at the bottom of this blog. This is a breakout session from a financial reporting course released by Enterprise DNA. The session includes

Continue reading