Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I currently have a matrix with 20 rows of sale items. Columns are dates and values are percentages of items sold by that categoroy per month. I would like conditional formatting by row to see if the percentages increase or decrease but PBI is applying the formatting to the entire table instead of by row.
As you can see below, Orange for Jan in the bottom example correctly shows red as it's the lowest number in the Orange row
The top example, shows Orange in Jan as yellow as it's not the lowest number in the entire table
Solved! Go to Solution.
Hi @bryanc78 ,
You present a table with 3 colours do you want a diverging based on the value or do you want only to highlight the biggest one?
If it's a diverging then you need to create a measure simialr to the one below:_
Ranking =
RANKX (
FILTER (
ALL ( 'Table'[Item], 'Table'[Month] ),
'Table'[Item] = SELECTEDVALUE ( 'Table'[Item] )
),
CALCULATE ( SUM ( 'Table'[Percentage] ) ),
,
ASC
)
This will give you a ranking based on the row and month then use it in the condittional formmating:
Two remarks:
See PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @bryanc78 ,
You present a table with 3 colours do you want a diverging based on the value or do you want only to highlight the biggest one?
If it's a diverging then you need to create a measure simialr to the one below:_
Ranking =
RANKX (
FILTER (
ALL ( 'Table'[Item], 'Table'[Month] ),
'Table'[Item] = SELECTEDVALUE ( 'Table'[Item] )
),
CALCULATE ( SUM ( 'Table'[Percentage] ) ),
,
ASC
)
This will give you a ranking based on the row and month then use it in the condittional formmating:
Two remarks:
See PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |