May 2019 update - no conditional colloring in graphs

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?

Anonymous , 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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values