Forum Discussion
Conditional formatting on top 3 values from each row in matrix visual
Hi, lets say you have produced a table with the columns location, time and qty. Then you can either create a measure or a calculated column for this table. Here I take a calculated column and the top 2 values
IsTop2 =
var loc = TestTable[Location]
var thisQty = TestTable[Qty]
var ct = CALCULATE(count(TestTable[Qty]), FILTER(TestTable, TestTable[Location] = loc && TestTable[Qty] > thisQty))
return
if(ct < 2, "#009292", blank()) You then use the conditional formatting menu and select format by field and reference the IsTop2 field.
This highlights for example the background of the top 2 in some hex color as above.
I produced a table that will already shows the pivot values of the visual. The surely can be modified, but the principle should be the same.
Best regards
Christian
- Dhrutivyasa-0703 years ago
Helper I
thank you for the solution , but i am still facing challange Reason is i have column in multiple small tables so i am not able to create a column . any idea on this?
ex:
location column is in location table
sales in sales table .
challange is , while creating a column the location / sales table us is not detected.