Applying custom conditional formatting using a Measure in Power BI

preview_player
Показать описание
This video shows how to apply custom conditional formatting in Power BI using a measure. For example, if you want to base your formatting for each column individually to correct for seasonality, you can't use the original numbers. This video explains how to adjust formatting through a custom measure. This way of conditional formatting gives you limitless possibilities for your formatting rules.

WRITTEN ARTICLE:

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#ConditionalFormatting #PowerBI #BIGorilla
  1. BI Gorilla
  2. conditional formatting in Power BI
  3. DAX
  4. Conditional formatting
  5. Measure
  6. Power bi desktop
Рекомендации по теме
Applying custom conditional 0:05:22

Applying custom conditional formatting using a Measure in Power BI

Excel Conditional Formatting 0:09:40

Excel Conditional Formatting with Formula | Highlight Rows based on a cell value

Excel Expert Lesson 0:06:42

Excel Expert Lesson 1 5 Applying Custom Conditional Formatting Using a Formula

Conditional Formatting in 0:06:43

Conditional Formatting in Excel Tutorial

Conditional Formatting Based 0:03:34

Conditional Formatting Based on Another Cells Values – Google Sheets

Apply Conditional Formatting 0:16:28

Apply Conditional Formatting to Multiple Cells with a Single Formula in Excel

Excel How To: 0:09:29

Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting

Master Conditional Formatting 0:10:37

Master Conditional Formatting in Excel (The CORRECT Way)

Transform Your Power 0:06:03

Transform Your Power BI Reports with Conditional Slicers | Advanced Slicer Formatting Options

How to: Use 0:00:27

How to: Use Conditional Formatting Rules in Sheets

Apply Conditional Formatting 0:04:21

Apply Conditional Formatting to an Entire Row - Excel Tutorial

Highlight entire row 0:03:55

Highlight entire row in Excel with conditional formatting

Google Sheets: More 0:03:35

Google Sheets: More Advanced Custom Formulas for Conditional Formatting and Filtering by 2+ Criteria

Excel - Use 0:03:23

Excel - Use Conditional Formatting on a Cell Based on Another Cell's Value

5 Conditional Formatting 0:12:00

5 Conditional Formatting tips to make you a rock star at work 🤘

Excel Conditional Formatting 0:09:23

Excel Conditional Formatting using Formulas

✅ How To 0:01:50

✅ How To Use Custom Formula In Conditional Formatting In Google Sheets 🔴

Google Sheets Checkbox 0:00:56

Google Sheets Checkbox - Apply Conditional Formatting across entire row

Use Conditional Formatting 0:04:51

Use Conditional Formatting to format another column in Power BI

Apply Color Scales 0:06:51

Apply Color Scales Conditional Formatting to Stock Returns in Excel

5.7.4.2 Conditional Formatting 0:02:32

5.7.4.2 Conditional Formatting in Google Sheets with a Custom Formula

[2024] - How 0:09:49

[2024] - How to Apply Custom Conditional Formatting to a Calculated Date Column in Microsoft Lists

Four SMART Ways 0:16:12

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

Conditional Formatting with 0:06:18

Conditional Formatting with Multiple Conditions in Excel

Комментарии
Автор

Great Trick Rick! Like that idea of putting a measure as conditional formatting in top of another measure. I will try this at work today. Thanks for posting. And yes, post some more Powerquery and DAX tricks. This was extremely useful. Happy new Year!

jazzista
Автор

Nice trick, very usefull. thanks for good explaining.

mfwuber
Автор

Thanks, its a great tip however I would like to know how to compare 1-Jan vs 1-Feb or 1-Feb vs 1-Mar, whether value is increased or decreased

SunilKumarMutte
Автор

Wow, that was so awesome... you are subscribed

oneallwyn
Автор

Hello, thanks for good tip, some custom visuals doesn't have conditional formatting, how can I add it to my visual ?

atiry
Автор

Hello!

Is there a way to conditional formatting a column inside a matrix that comes from an unpivot column, I try this rule but it doesn't work properly:

Rule = IF(MAX('Backlogs list testing'[Month])="06 June OA vs Actuals", 0

I need to apply the conditional formatting to just one column.

Thanks in advance.

josemarquez
Автор

How do i compare adjacent columns in a matrix; if column 1 > column 2 then show down error icon?

siphesihleyapi
Автор

Hello, thank you for your efforts, please I have a question about tables ..can I make condition date formula or some rules in order to change the rows color in terms of what I want ? is there any way to cotrole the row color by condition date ?
i know that you can change the row color but not by a condition that you made. for example if date A < date B make the row in red color etc ... thank you for your help

hamzamottali