Tag: ALLSELECTED function

DAX Examples In Power BI – Advanced DAX Formulas

In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make

Continue reading

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Conditional formatting is a way of visualizing data by applying a certain set of format rules based on user-defined conditions. For Power BI visuals, it is mostly used when presenting data in a tabular form. In this tutorial, I’ll discuss how to combine DAX formulas with the new conditional formatting feature to highlight the last

Continue reading

Power BI Data Visualization Technique: Creating A Dynamic Heading Or Title

Over the years, visual headers have significantly improved. You can now use these headers to enhance the appearance of your reports. These headers also come with headings or titles. In this tutorial, I’ll be showing how you can create a Power BI dynamic title or heading in your reports. A dynamic title or heading can

Continue reading