Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear Users
i want to apply conditional formmating in powerBI same as shown in below table.
i want to highlight only 1 cell in entire matrics . i have tried top 1 and ranx functions but not able to achieve desired result.
thanks in advance.
Solved! Go to Solution.
hi @Dhrutivyasa-070 ,
supposing you have a data table like:
Year | Month | Value |
2023 | June | 500000 |
2023 | June | 500000 |
2022 | June | 67 |
2023 | July | 90 |
2022 | July | 10 |
try
1) plot a matrix visual with year column, month column and a measure like:
Sum = sum(data[Value])
2) conditionally formatting the [Sum] field with a measure like:
Color =
VAR _max = MAXX(ALLSELECTED(data), [Sum])
VAR _result = IF( [Sum] = _max, "Green")
RETURN _result
it worked like:
for more info:
https://databear.com/changing-colours-using-dax-and-conditional-formatting-in-power-bi/
FormatMeasure=IF([Measure]=MAXX(SUMMARIZE(ALLSELECT(Table),Table[Year],Table[Month]),[Measure]),"green")
hi @Dhrutivyasa-070 ,
supposing you have a data table like:
Year | Month | Value |
2023 | June | 500000 |
2023 | June | 500000 |
2022 | June | 67 |
2023 | July | 90 |
2022 | July | 10 |
try
1) plot a matrix visual with year column, month column and a measure like:
Sum = sum(data[Value])
2) conditionally formatting the [Sum] field with a measure like:
Color =
VAR _max = MAXX(ALLSELECTED(data), [Sum])
VAR _result = IF( [Sum] = _max, "Green")
RETURN _result
it worked like:
for more info:
https://databear.com/changing-colours-using-dax-and-conditional-formatting-in-power-bi/
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |