Collin Quiring on 22 Oct 2019 03:40:22
We often have columns or measures that we want to be formatted the same in EVERY report tab in EVERY visual the same way. There is no universal method to format a measure in every visual in a report. We have to go into each visual on each report tab and do the exact same field formatting (colors, etc.) in each visual. We would like there to be a Universal option.
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?
- Comments (118)
- Merged Idea (15)
RE: Field Format - Report Wide
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.
RE: Field Format - Report Wide
Lock colours on certain data catagories in order to prevent colour clashes upon refresh. For example when producing a dashboard that contains an overview of competitors across the region; there are some major competitors which one would compete against in a number of markets; it would be useful to assign these competitors a colour. However, when the data looks at different markets, suddenly you get colour clashes which makes it more difficult to interpret data. This makes it harder to drive consistent visuals.
RE: Field Format - Report Wide
There is dire need to have this functionality implemented for the line charts to retain the data colors(user specific hexacode in automated fashion) for the same data points across the different line charts. We need the functionality to change the colors using measure.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13757925-dynamically-specify-data-colour-using-column-e-g
RE: Field Format - Report Wide
It should be possible to set the data colors of all common fields in different charts and pages of the report to the same color without changing each color of each chart manually which takes time. It would be great if these defaults could be set programmatically and use hex codes from a table and then assign them to their relevant fields across all visuals.
RE: Field Format - Report Wide
It’s good that you added it, but it’s really some basic alpha-beta level only, in my opinion. It should enable the users to conditionally-format also the dimensions (Attributes) and not only measures (Metrics).
For example I have got a report with Revenue $ by region (AMER / EMEA / APJ) and i want the colors of the whole row / column / field to be cahnged based on the Region dimension OR Revenue measure).
Today, we can do only set up a simple conditions to measures.
RE: Field Format - Report Wide
It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.
RE: Field Format - Report Wide
I would like the option to set global data colors for my reports based on a specific field within the data, that will impact all charts using that field.
For example, in our current data set we have a field 'Customer'. Each customer is assigned their own unique color that corresponds to our other documentation, to make charts easier to interpret.
Currently, I have to set the 'data colors' options for every single chart that uses the 'Customer' field. Whenever a new customer appears in our data set, I have to modify the data colors for multiple charts individually.
I would like the option to be able to set data colors for this field on a report-level basis.
RE: Field Format - Report Wide
Fully agree! This is essential. The same idea has already been presented:
Conditional Formatting throughout (829 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=59734f89-363d-41e8-be27-f123765dfd2f
Field Format - Report Wide (798 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=a24b6ebf-14a5-4134-b6ae-a765b407b007
Set data colors programmatically in power desktop (40 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=a7b30bd6-7827-4311-9ff1-d5746e50f10b
RE: Field Format - Report Wide
Consistent colors definitions should be applied at measure or field level. Check: https://ideas.powerbi.com/ideas/idea/?ideaid=890487c2-6bd2-eb11-ba5e-281878bd2252