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.
I'm working on a report, that has two categories for an alarm, and on the charts one is as a light blue and the other a dark blue. I have made a donut chart with the card inside to show the total count of each, and a slicer to select which one the user wants to focus on.
The issue is on the card, as I click on the dark blue category, all charts display dark blue, which is right, but the callout card doesn't so it looks a bit off and can be confusing. I looked at the conditional formatting in the card, but there is no way for me to select the colour by category, only by value range. Is there a way I can set up the callout value colour by category? So it would change the colour accordingly to the category?
Solved! Go to Solution.
Hi @Amazing_Random ,
This is my test table:
The charts I created:
Please create a measure:
Measure = SWITCH(
TRUE(),
SELECTEDVALUE('Table'[Attribute]) = BLANK(),"black",
SELECTEDVALUE('Table'[Attribute]) = "Sales","#12239E",
SELECTEDVALUE('Table'[Attribute]) = "Quantity","#118dff"
)
Conditional formatting for callout value:
When you click on the dark blue category:
When you click on the light blue category:
IIf you don't click any category, the default color for callout value is black:
The effect is the same if you choose a slicer.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Amazing_Random ,
This is my test table:
The charts I created:
Please create a measure:
Measure = SWITCH(
TRUE(),
SELECTEDVALUE('Table'[Attribute]) = BLANK(),"black",
SELECTEDVALUE('Table'[Attribute]) = "Sales","#12239E",
SELECTEDVALUE('Table'[Attribute]) = "Quantity","#118dff"
)
Conditional formatting for callout value:
When you click on the dark blue category:
When you click on the light blue category:
IIf you don't click any category, the default color for callout value is black:
The effect is the same if you choose a slicer.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
102 | |
75 | |
44 | |
39 | |
32 |
User | Count |
---|---|
161 | |
87 | |
64 | |
46 | |
42 |