Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to get Dynamic color Green for Maximum value and Red for Minimum value in my column chart with field parameter.
Please advise how can it be done?
As per below example
Solved! Go to Solution.
Well, this got really ugly really fast...
bar color =
VAR da =
MAX( 'Date Axis'[Date Axis] )
VAR ma =
MAX( 'Measure Axis'[Measure Axis] )
VAR ts =
SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
VAR mv0 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Stat of Qtr],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv1 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Start of Month],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv2 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Week Start],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv3 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Date],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
RETURN
SWITCH(
da,
"Stat of Qtr",
SWITCH(
TRUE(),
ts = MAXX( mv0, [v] ), "green",
ts = MINX( mv0, [v] ), "red",
"blue"
),
"Start of Month",
SWITCH(
TRUE(),
ts = MAXX( mv1, [v] ), "green",
ts = MINX( mv1, [v] ), "red",
"blue"
),
"Week Start",
SWITCH(
TRUE(),
ts = MAXX( mv2, [v] ), "green",
ts = MINX( mv2, [v] ), "red",
"blue"
),
"Date",
SWITCH(
TRUE(),
ts = MAXX( mv3, [v] ), "green",
ts = MINX( mv3, [v] ), "red",
"blue"
)
)
see attached
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Thank you for your response.
Please refer the attached file as per your requirement.
Well, this got really ugly really fast...
bar color =
VAR da =
MAX( 'Date Axis'[Date Axis] )
VAR ma =
MAX( 'Measure Axis'[Measure Axis] )
VAR ts =
SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
VAR mv0 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Stat of Qtr],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv1 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Start of Month],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv2 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Week Start],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
VAR mv3 =
CALCULATETABLE(
SUMMARIZE(
'Date',
[Date],
"v", SWITCH( ma, "Total Sales", [Total Sales], "Unit Sold", [Unit Sold] )
),
ALLSELECTED()
)
RETURN
SWITCH(
da,
"Stat of Qtr",
SWITCH(
TRUE(),
ts = MAXX( mv0, [v] ), "green",
ts = MINX( mv0, [v] ), "red",
"blue"
),
"Start of Month",
SWITCH(
TRUE(),
ts = MAXX( mv1, [v] ), "green",
ts = MINX( mv1, [v] ), "red",
"blue"
),
"Week Start",
SWITCH(
TRUE(),
ts = MAXX( mv2, [v] ), "green",
ts = MINX( mv2, [v] ), "red",
"blue"
),
"Date",
SWITCH(
TRUE(),
ts = MAXX( mv3, [v] ), "green",
ts = MINX( mv3, [v] ), "red",
"blue"
)
)
see attached
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |