Highlight LOWEST and HIGHEST Periods Dynamically on Power BI Chart

Super User

5 years ago

If you need to know the lowest and the highest cumulative periods, we can create a cumulative total measure, and apply conditional formatting to highlight it. We can also make it dynamic, by providing a parameter to define the cumulative days. Along the way, you will learn, how to implement the calculation logic combining different DAX functions to build effective measures.

💚 Subscribe to my YouTube channel to stay up to date with Power BI videos:

You can find the download link to the completed Power BI file in the video description.

Please leave your comments and questions below.
Thanks

Updated 5 years ago

Version 3.0

How To

tips & tricks

Fowmy

Super User

I’m a Microsoft-certified BI professional with a solid background in finance, accounting, and data analytics. My main focus is on Power BI and Microsoft Fabric development, where I work on building BI solutions, consulting, and corporate training. I enjoy helping others develop their skills in data analytics and stay active in community forums to keep up with the latest trends and best practices in the field.

View Profile

Power BI Community Blog

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.

Blog Post

Highlight LOWEST and HIGHEST Periods Dynamically on Power BI Chart