Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |