Forum Discussion
Anonymous
5 years agoNot applicable
Conditional Formatting for Color in Bar Chart
Hi, Let say I have below table Network Product Network A Pencil Network A Book Network A Pen Network B Knife Network B Pan Network C Bed Network C Pillow I ...
v-robertq-msft
5 years agoCommunity Support
Hi, Anonymous
According to your description and Follow-up, I can clearly understand clearly what you want to get, you can create a measure like this:
Color =
SWITCH(
MAX('Table'[Network]),
"Network A","Red",
"Network B","Yellow",
"Network C","Grey")
Then you can create a column chart and place it like this, then set the conditional format for the data color using lkalawski’s solution, like this:
And you can get what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.