Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Fowmy

Supercharge Your Visuals: Easy Conditional Formatting in Power BI Without DAX

Are you looking to add an extra layer of insight to your Power BI visualizations without diving into complex DAX expressions? Well, buckle up because I'm about to share a simple yet powerful technique that allows you to highlight maximum and minimum data points on your visuals with ease.

 

In Power BI, conditional formatting is a powerful feature that allows you to visually emphasize certain data points based on specific conditions. Typically, highlighting maximum and minimum values would involve writing DAX expressions. However, there's a lesser-known method that achieves the same result without touching a single line of DAX code.

 

Begin by selecting the visual element (e.g., column chart, bar chart, etc.) where you want to highlight the maximum and minimum data points. In this chart, I need to highlight the bars for the highest and the lowest sales based on the Total Sales measure used here.

 

Fowmy_0-1713294654967.png

 

Next simply click on the "FX" button located within the Column formatting section of the visual to apply the conditional formatting.

 

Fowmy_1-1713294666392.png

 

Apply percentage-based formatting rules to the visual using the Total Sales measure. Set 100% for the maximum value and 0% for the minimum value, then click OK as shown below.

Fowmy_2-1713294682992.png

 

 

In this illustration, observe the column chart where the highest and lowest data points are emphasized through percentage-based formatting rules. Take note of how the tallest and shortest columns catch the eye, effectively highlighting extreme values without relying on complex DAX computations.

 

Fowmy_3-1713294712965.png

 

If you wish to assign a distinct color to data points other than those representing the maximum and minimum values in the bars, you can add a rule at the top as outlined below:

 

Fowmy_4-1713294738808.png

Fowmy_5-1713294758685.png

 

In conclusion, utilizing percentage-based formatting rules in Power BI empowers you to easily emphasize maximum and minimum data points in your visuals, enriching their clarity and visual attractiveness. This approach simplifies the process while offering enhanced flexibility and creativity in designing your dashboards.

 

Next time you aim to elevate the visual appeal of your Power BI reports, keep this handy technique in mind to breathe new life into your visuals. Stay tuned for additional tips and tricks to optimize your Power BI experience. Until then, happy visualizing

 

Comments

I have a website and use Google Analytics to find out analytics reports, my website is a friend of Indonesian e-wallet. Can I use Power BI to create visual data reports?

@speedcashindo 

Yes, you can connect to your website and the related data source using multiple available connection methods to visual the data using Power BI. You may send the details to gfowmy@gmail.com for further understanding of your requirements.

Thanks
Fowmy