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.
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.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |