Column and Dot Chart - Colors and Labels

Question

Trying to show the absolute number and % (secondary Y-axis) for each category, so each column should have its own color.Using Line and Stacked Column Chart, I put the absolute number as column value and % as line, while putting the same category value both as Shared Axis and Column Series.Problem is, I get a dot for each % that doesn't match the color of the column. I also couldn't find a way to show only labels for one of the values (just line/just column).Any ideas on how to solve this/other solution?&nbsp;&nbsp;&nbsp;

parry2k · Answer

nadavbi&nbsp;I spent sometime to figure out if there is any way but no success. I guess this is something you need to post on ideas forum and might get some attention. You can manually change the color for 2nd axis (line chart) but I know it is not very scalable solution. I was also thinking to use&nbsp;Measure for the color and I tried it, but no success. All of all it looks like it is not possible to achieve what you are looking for. Great question though.
&nbsp;
You can surely look at custom visuals at market place if something fulfill your needs. Good luck!
&nbsp;
Would appreciate Kudos 🙂 if my solution helped.

nadavbi · Answer

Thanks. As far as I see it when I apply the settings that get these dots (instead of a line), there's no real option to change even manually their colors

parry2k · Answer

nadavbi&nbsp;you cannot manually change the color of bars but you can manually change the colors of line/dots
&nbsp;

alex_mikhnev · Answer

Hi, Could you provide me which visual did you use? I wanted to build visual "Dots and Columns" as your on screenshot, but I don't understand how I can do it....&nbsp;

parry2k · Answer

Alex_Mikhnev&nbsp;on the format page change the stroke width to 0 and turn on the markers&nbsp;

&nbsp;
Subscribe and watch Fabric and Power BI videos at youtube.com/@PowerBIHowTo
&nbsp;
&nbsp;

Forum Discussion

Related content

Stacked Column Chart Data Labels

Data Labels Colors

Button Slicer - Label text colors not working?

Set Reference Label Background Color Conditionally

conditional color Stack column chart