cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper V

## 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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors