Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All
I have a Qtr bar chart , i like to make all Q1 bar same color . i have try measure , i get error :-
color by qtr = Switch(max('Date'[year]),
Q1, "green",
Q2, "blue",
Q3, "red",
Q4"grey"
)
My PBI file :-
Paul
Solved! Go to Solution.
Hi Paul,
This code works
color by qtr =
VAR __Qtr = SELECTEDVALUE('Date'[Year Quarter])
RETURN
SWITCH(
TRUE(),
CONTAINSSTRING(__Qtr, "Q1"), "green",
CONTAINSSTRING(__Qtr, "Q2"), "blue",
CONTAINSSTRING(__Qtr, "Q3"), "red",
"gray"
)
Regards
Phil
Proud to be a Super User!
Hi @admin11 ,
Please update the formula of measure [color by qtr] as below:
color by qtr =
SWITCH (
RIGHT ( SELECTEDVALUE ( 'Date'[yrqtr] ), 2 ),
"1Q", "Green",
"2Q", "Blue",
"3Q", "Red",
"4Q", "Grey"
)
Best Regards
Hi @admin11 ,
Please update the formula of measure [color by qtr] as below:
color by qtr =
SWITCH (
RIGHT ( SELECTEDVALUE ( 'Date'[yrqtr] ), 2 ),
"1Q", "Green",
"2Q", "Blue",
"3Q", "Red",
"4Q", "Grey"
)
Best Regards
Hi Paul,
Didn't my code work? It produces the results you asked for?
Phil
Proud to be a Super User!
Hi Paul,
This code works
color by qtr =
VAR __Qtr = SELECTEDVALUE('Date'[Year Quarter])
RETURN
SWITCH(
TRUE(),
CONTAINSSTRING(__Qtr, "Q1"), "green",
CONTAINSSTRING(__Qtr, "Q2"), "blue",
CONTAINSSTRING(__Qtr, "Q3"), "red",
"gray"
)
Regards
Phil
Proud to be a Super User!
I am sorry , i miss your reply. i just tested your is working fine.
also your code more easy to understand.
Paul
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |