And, you know what will come next? :-) No doubt, somebody will want the formatting to be report wide EXCEPT for one single visual somewhere. Is that possible too?
The lack of this feature seems to be a recurring habit of Microsoft in the Power Platform, I remember working with Power Apps at one point and that suffered the exact same problem.
Can we get some QoL features please Microsoft?
This is the kind of the thing that leaves you wondering, in 2022... how this is isn't already a basic-included feature?
Currently the "based on field" formatting (identified by the button "fx" under "Data Colors") is not available for all the standard visuals (like line chart, area chart, stacked area chart, pie chart, donut chart).
This option (available only for the bar/column chart visuals) disappears if a database field is assigned to "Legend". Consequently the only way to customise the colors is by manually selecting them for each case!
Check the comments under this said to be closed idea:
The other thread requesting this feature indicates completed, but there are a number of other comments indicating that the fix isn't applied to all built in visuals. - please vote up this idea to get the other visuals fixed as well.
Achieving some color consistency in PowerBI is a major pain and it seriously impacts experience and productivity.
Two major improvements could be implemented
-Measure default color - ability to assign a default color to any measure, to be used in relevant charts (line, bar, areas...) .
-Color assignations to field values - Ability to assign colors to field values, so that the color for dimensions stays consistent across charts. It could be similar to the "Data colors" feature, but not linked to a specific visualization.
Need to be able to assign colors for specific data sets. I work on healthcare architecture projects and would like to be able to set "cardiology, primary care, oncology" etc. to a certain hex code to always be represented as the same color across pages. JSON files don't seem to be able to tag a color to a certain data label. Sorry - new to PowerBI. I realize I'm likely using beginning language!
I am a user that came from QlikSense and this is one of the things I think PowerBi could improve a lot!
In Qllk , the user has the option to create master dimensions or measures and assign specific colors to them!
So, it does not matter when the user uses that attribute, will always be the same color.
All the charts have also the option of formating by dimension. And it does not matter it is a bar chart, a combination chart os a Scatter-Plot ploot , when you use this option you guarantee that the same dimension will always have the same color which makes a lot of sense ( I don't want in one chart the country US show with Green and the other with Blue.. that just create confusion) .
I been trying the same thing in Power BI, but I came to the conclusion that this is not possible. Some charts I can try to put the dimension as a legend, but no ALL charts, and the colors are not consistent between charts! I try to create a table with the colors code and the field, but that is not very practical.
I have a personal finance dashboard, so you can imagine I have a lot of categories and want to keep the colour consistency between charts.
Hope this Improve because the tool is amazing!
Use conditional color at data color for pie chart.
I want to create a theme where the colors for a barchart (and others) are configured by name of the measure.
for example: invoice $ measure should be in green, invoice target in yellow, claims in red etc...
so when I apply my theme, everywhere where my invoice $ measure is used and a color can be set, I should have it in green.
When creating multiple Graph visualizations in a report (or on the same report page), the graph lines colors are predetermined. For example the first Value is Green, then Black, then Red etc.
Often I use the same measures as line graph values in my reports. Each time I have to manually change the line data color to be consistent with other graphs on the same report page or a different report page.
So for example the 'Turnover year line 2016 per month' should have a blue data color in all graphs of the report. This enanches your report/dashboard on user friendly.
It would be great if you can predetermine that a particular measure always has a consistent layout in your report.