Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am on PBI Desktop V 2.106(June 2022)
The Data Colors option is missing from the Format visual Menu. So far it's missing from the Donut, stcked column, and matrix charts that I can tell, but I haven't checked any others.(see screenshot).
Go to the Visualizations > Visual > Columns and see if there is a Series drop down menu in a section named "Apply settings to".
If this is set to "All" you will only have the option to change overall transparency in the Columns > Color section.
Try changing the Series from All to one of the column names in your chart and it should add a Color drop down menu in the Columns > Color section.
Hopefully this helps!
i am using the stacked bar chart and couldn't find the column option here. instead i have x-axis and y-axis separately. unable to find any option for data colors
Hope this helps
Found it, but the new way to set data colours is a disaster. Soo hard to find. Thanks for solving.
Hope this helps. For the donut chart you can see colour when you expand the 'slice' option
i am using the stacked bar chart and couldn't find the column option here. instead i have x-axis and y-axis separately. unable to find any option for data colors
@Padycosmos Yes, that does solve the donut chart colors. Thanks! Now hopefully somebody can chime in on the column chart Data Colors not showing up.
This is for the stacked column chart. Expand the Columns option to find the colors
I have the same issue, i missing the option to set colors by function!
Were you able to figure it out I'm having the smae problem
No, unfortunately, I haven't found a solution. It is possible to set colors for individual categories, but not through a function. I have the same categories in many charts repeatedly, and I want to use the same colors for these categories in all charts to quickly provide the user with an overview based on colors. Currently, this seems not possible, and I would also appreciate a solution to this problem.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |