May 2019 update - no conditional colloring in graphs

[kiryl]

Hi,

I am using May 2019 version and I'm missing of conditional coloring for data in graphs.

I thought this functionality was added in November 2018 update?

[kiryl · Accepted solution]

hi @amitchandak

I wanted to use Line and clustered columns chart. I put:

- item type into Shared axis

- date into Column series, and

- stock amount into Column values

After removing date, I managed to get conditional formating accessable, so thanks 🙂

But the issue is, I have to show somehow treshold values for every item on each date. I guess I need to use separate visual for each item.

Is there a way to set data color based on it's value in comparison to other fields values?

[amitchandak]

@kiryl , Are you using legend in the visual? I can see the "Fx" icon near to data color. Which visual you are trying. Also check your version in file-> About

[kiryl · Accepted solution]

hi @amitchandak

I wanted to use Line and clustered columns chart. I put:

- item type into Shared axis

- date into Column series, and

- stock amount into Column values

After removing date, I managed to get conditional formating accessable, so thanks 🙂

But the issue is, I have to show somehow treshold values for every item on each date. I guess I need to use separate visual for each item.

Is there a way to set data color based on it's value in comparison to other fields values?

[amitchandak · Accepted solution]

@kiryl , as long as conditional formatting is allowed. You can always create a color measure and use that after choosing field option

Same or different measures

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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[kiryl]

@amitchandak , it turned out that I came up with the similar sollution

STOCK COLOR = 
  if(
    'Loans_stock_arms'[STOCK Thr] <= related('Stock Thresholds'[RED]),
    "#FF0000",
    if(
      'Loans_stock_arms'[STOCK Thr] <= related('Stock Thresholds'[ORANGE]),
      "#FFBF00",
      "#00FF00"
    )
  )

but your sollution shows how to do it properly 🙂 thanks