Forum Discussion
Dax Warning measure
Hi all,
I have a dax query which looks like this
I have 3 types of spreads -
original - current - difference
Would this be possible?
Hi Anonymous ,
According to your description, you want a separate column to highlight when the Current column falls under 2, here's my solution.
1.Create a blank column.
Column = BLANK()2.In the Visuallizations pane, select the new column, turn on the Background color.
Set it like this:
Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Anonymous , I doubt I completely got it. But seem like it require two measures one return color and another unichar
example
/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)
/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692I need little bit more details to help
Hi I was wondering if this was something you could help me with please?
v-yanjiang-msftCommunity Support
Hi Anonymous ,
According to your description, you want a separate column to highlight when the Current column falls under 2, here's my solution.
1.Create a blank column.
Column = BLANK()2.In the Visuallizations pane, select the new column, turn on the Background color.
Set it like this:
Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
