Tag: Conditional Formatting

Custom Visual In Power BI: Learn How To Control Font Properties In DAX

For this blog post, I want to take some time today and introduce you to a custom visual in Power BI that I’ve started using which provides a lot of flexibility and capabilities that are not possible within native Power BI visuals. You can watch the full video of this tutorial at the bottom of

Continue reading

First N Business Days Revisited – A DAX Coding Language Solution

Let’s take another look at the problem discussed in this tutorial, which dynamically compared the first N business days of each month. This problem was based on a query from an Enterprise DNA member on our forum, where he wanted to dynamically look and compare the first 5, 10, 15, and 20 billable days (the

Continue reading

Conditionally Format Charts Using Charticulator

Conditionally-Format-Charts-Using-Charticulator

In today’s blog, we’re going to discuss a question that was recently posted on the Enterprise DNA forum about Charticulator. David Joy, one of the members of the forum, had a question about one of Mudassir’s videos from his data visualization course. He wanted to know how to format charts and conditionally highlight the MAX

Continue reading

Native Visuals In Power BI: Basic Charts

Power BI offers a group of native visuals that we can use to build dashboard visualizations. In this tutorial, we’ll discuss how to use native visuals in Power BI creatively. We’ll be focusing on how to use the three basic charts (Bar Chart, Comparison Bar Chart, Line Chart) in Power BI along with their limitations.

Continue reading

Calculate Percentage Margin In Power BI Using DAX

Calculate Percentage Margin In Power BI Using DAX

Today, I’m going to do a quick and easy tutorial on how to calculate one of the most commonly used metrics, especially if you’re dealing with sales, revenues, or transactions. We’ll calculate the percentage margin. I’m going to use profit margin as an example here, but this technique doesn’t have to be always related to

Continue reading