Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
i want to apply conditional formatting in a matrix for each row separatly instead of comparing all rows along the matrix
for example, in the image below, for each item im grouping data by month and i want to apply conditional formatting to compare values for each specific item in the selected months but seperated from other items
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please try the below.
I tried to create a sample pbix file like below, and the conditional formatting for the background color can be based on the [Ranking in a group measure].
Value total measure: =
SUM( Data[Value] )
Ranking in a group measure: =
VAR _grouptable =
CALCULATETABLE ( Data, ALLEXCEPT ( Data, 'Group'[Group] ) )
RETURN
RANKX ( _grouptable, [Value total measure:],, DESC )
Hi,
I am not sure if I understood your question correctly, but please try the below.
I tried to create a sample pbix file like below, and the conditional formatting for the background color can be based on the [Ranking in a group measure].
Value total measure: =
SUM( Data[Value] )
Ranking in a group measure: =
VAR _grouptable =
CALCULATETABLE ( Data, ALLEXCEPT ( Data, 'Group'[Group] ) )
RETURN
RANKX ( _grouptable, [Value total measure:],, DESC )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |