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 learn if it is possible to change color for each column in stacked column chart as below (I did it as an example in pic editor.)
Main goal is to show each column where the competitor is from, for example
if he/she is from USA, column will be in Blue tones,
if he/she is from Italy column will be in green tones
if he/she is from Russia column will be in red tones
Competitors from other countries will be in all grey tones.
And also that tones will be in 3 shades of the selected colors , depends on the type of medals.(gold-silver-bronze)
Thank you in advance.
@Anonymous ,
Conditional formatting for bar is achievable but i doubt about the color shade changes for different categories.
please refer the below,
BAR CF =
SWITCH(TRUE(),SELECTEDVALUE(financials[Year])=2014,"Blue",
SELECTEDVALUE(financials[Year])=2013,"#FFC200")
It doesnt work 😞
and i have to problem
1) country color
2) medals shading according to country.
@Anonymous ,
you have to use the measure in conditional formatting option setting- here
set your measure like this,
For only one factor, your formula works great, but as i told, there are 3 more factors, Gold-Silver-Bronze, do you have any idea about it ?
Hi, @Anonymous
Unfortunately, power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Community Support Team _Charlotte
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |