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 (123)
- Merged Idea (15)
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
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
RE: Field Format - Report Wide
Have been waiting for something to solve this since starting using PBI. Exactly as the poster described - per-customer colours on all visuals and shared between reports
RE: Field Format - Report Wide
It's very important to have data color conditional formatting in charts with a legend (line charts, bar/column charts, scatter chart, pie chart). Color is one of the most important attributes in data visualization and currently we can't really control data colors when we need (for example when we have multiple lines on a line chart). Proper use of data colors currently is possible only using workarounds (caclualtion groups, overlays of transparent visuals).
RE: Field Format - Report Wide
This would be so helpful. Having to format individually is back to Excel which we are trying to get away from.
RE: Field Format - Report Wide
Yes please. This would be a timesaver. Hopefully for the Report Server version too!
Thank you!
RE: Field Format - Report Wide
Yes, this would be so helpful! I had the exact situation as the Canada example. It will try to color code based on how they are sorted in the chart, so if you have multiple charts showing different sets of data, but Canada is the highest in one and the lowest in the other, it will be a totally different color. Hard to track the same country across the different visuals.
RE: Field Format - Report Wide
#,#;[Red](#,#);"-" add colour to custom format
RE: Field Format - Report Wide
Very needed!
RE: Field Format - Report Wide
'Perhaps similar to this request. But to clarify looking for the same measure across different charts and different pages to maintain :
1. Consistent Data Colors - If color is changed on one chart, change is applied across all charts in the same file
2. New Chart - If new chart is created in same file and metric with previously defined color is added to new chart, previously assigned color would be "auto-assigned" instead of default color
3. If 1 and 2 are not possible based on some other restriction the ability to import metric specific color scheme via lookup table that would drive this
Nice to have:
- Less clicks to get to HEXCODE editor
- Options for different color selector ie. wheel, square, circle, etc..
- Changing color in right click menu on legend or graph part