Forum Discussion
Solved
Different Conditional formatting rules for each value in x-axis
I have a column chart with region on the X-axis (A,B,C,D,E). Each region has a different percent requirement (i.e. A=5%, B=4%, etc). Is there a way to have diverging conditional formatting that is se...
- Have you created a relationship between the Target table and the Store or Sales table? If you do this, and the column chart has StoreID on the Axis, then the MAX() part of the formula should find the MAX target% for the selected storeID in the column visual. If you're trying to do this for more than one store at a time, you'll need to create a more complex measure and explain further what you need.
You should be able to use SELECTEDVALUE(Target[Target]) instead of MAX if that makes more sense.
If you want to you could build out the DAX further to add some error checking:
IF(HASONEVALUE(StoreID), Measure)
Have you created a relationship between the Target table and the Store or Sales table? If you do this, and the column chart has StoreID on the Axis, then the MAX() part of the formula should find the MAX target% for the selected storeID in the column visual. If you're trying to do this for more than one store at a time, you'll need to create a more complex measure and explain further what you need.
You should be able to use SELECTEDVALUE(Target[Target]) instead of MAX if that makes more sense.
If you want to you could build out the DAX further to add some error checking:
IF(HASONEVALUE(StoreID), Measure)
You should be able to use SELECTEDVALUE(Target[Target]) instead of MAX if that makes more sense.
If you want to you could build out the DAX further to add some error checking:
IF(HASONEVALUE(StoreID), Measure)
Thanks AllisonKennedy I got it to work. I used your solution. The problem was in my relationship. I needed to set it as Both for Cross filter direction. I was also able to build in the yellow range.