cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver III

## DAX MODIFICATION

There are three measures to set color for a column in a table visual
i.e

1) SUB1_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

2) SUB2_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB2_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

3) SUB1_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))
Needed measure is a single measure
which can work on multiple selected values for multiple measures
Thanks

Super User

Hi,

It is a bit unclear what your goal is but for now I will assume the following:

1. You have multiple slicers that you want to determine your color
2. The measure should work with multiple measures

Dax:

Color combination switch =

var _color1 = MAX('Color1'[Color1])
var _color2 = MAX('Color2'[Color2])
var _color3 =MAX('Color3'[Color3])
return

SWITCH(_color1&_color2&_color3,
"AAA","#fcdc9c",
"AAB","#9df2d1",
"AAC","#95bcf5",
"ABA","#fcdc9c",
"ACA","#9df2d1",
"ABB","#95bcf5") //Continue the logic

This measure will return a color based on the state of the 3 slicers.

E.g.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.