Forum Discussion
Value conditional formatting by Product in Rows -Price
Hi Team,
How can I color code price (min red and max green) by product in Matrix table?
I'm trying to compare price of 3 different product by weeks and I need to highlight when price goes to minimum/promotional week to make sure we dont have clash between skus?
As an example:
On 18th of Jan I have 2 promo price ($6 and 10$) and I want to highlight it with red and $4.71 should stay green.
Appreciate your help!
Aidar
3 Replies
Anonymous , Not very clear. But you can create a color measure and use that is conditional formatting using field value option
example
color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)Refer : https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesThanks for the reply,
I'm trying to find minimum value for in selected table by product and then I will set up my contiondal formating.
Currently, I use below
Matrix table
MIN WTD RRP = CALCULATE(MINX(Pricing,Pricing[WTD Round RRP]),ALLSELECTED())But it gives me minimum across all 3 product (as example below $3.5) while I need $3.5 for Product 1, $6.0 for P2 and $10.0 for P3Hope it make sense. Appreicate your help!
Hi Anonymous ,
Please refer to this post: Determine Minimum and Maximum Value in Row in Matrix.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
