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 (119)
- Merged Idea (15)
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
RE: Field Format - Report Wide
Much needed functionality. When this will be available?
RE: Field Format - Report Wide
I concur! Manually creating category/color uniformity across reports for my users is time consuming. I wish weekly, sometimes daily, that this feature existed.
RE: Field Format - Report Wide
Wouldn't it make sense to have a Color Values box on the 'fields' view that you could drop a column into to set color values instead of having to go into the format view?
When you have a multi-page report with 4 to 7 Line and stacked column charts per page, it takes significant time to update all of them.
RE: Field Format - Report Wide
Please make this an option - it's so fiddly and time consuming have to go to each individual visualisation and then select the data colours!