Skip to main content

    Power BI

    Under Review

    Field Format - Report Wide

    Vote (3278) Share
    Collin Quiring's profile image

    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)
    Collin Quiring's profile image Profile Picture

    Dawn Peacock on 06 Jul 2020 00:14:27

    RE: Field Format - Report Wide

    Yes, PLEASE! I am constantly having to change data colors for the same field being used across multiple pages. I'd use a measure to set the color but my boss prefers PieCharts and DonutCharts for a certain analysis and the advanced controls for data colors aren't enabled there.

    Collin Quiring's profile image Profile Picture

    Blanca on 06 Jul 2020 00:13:37

    RE: Field Format - Report Wide

    Black format as it was before

    Collin Quiring's profile image Profile Picture

    Antoine AVIAT on 06 Jul 2020 00:13:12

    RE: Field Format - Report Wide

    Share that one so it gets more vote... ;)

    Collin Quiring's profile image Profile Picture

    Madhan on 06 Jul 2020 00:13:10

    RE: Field Format - Report Wide

    Conditional formatting for line chart is very much required .. please ..

    Collin Quiring's profile image Profile Picture

    Collin Quiring on 06 Jul 2020 00:12:54

    RE: Field Format - Report Wide

    Agreed, this is like the Canada example below.

    Collin Quiring's profile image Profile Picture

    Dan on 06 Jul 2020 00:11:39

    RE: Field Format - Report Wide

    Similar idea has more votes:

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

    Collin Quiring's profile image Profile Picture

    Dan on 06 Jul 2020 00:11:39

    RE: Field Format - Report Wide

    I don't believe they were talking on the template or theme level. More like if country was a dimension, any time Canada would be represented in a bar or line plot, it would be a red bar or line. Mexico would be a green bar or line, etc. Could do it with some DAX and rules if the Data Color property had conditional formatting.

    Similar IDEA: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

    Collin Quiring's profile image Profile Picture

    Ken Robertson on 06 Jul 2020 00:09:49

    RE: Field Format - Report Wide


    Filter to show the graphics as they appear to a color blind user?

    Collin Quiring's profile image Profile Picture

    Tad Borowski on 06 Jul 2020 00:08:57

    RE: Field Format - Report Wide

    Do Templates and Themes not accomplish what you are looking for?

    Collin Quiring's profile image Profile Picture

    Tom on 06 Jul 2020 00:04:12

    RE: Field Format - Report Wide

    Being able to conditionally format all my graphics (shapes) and text for KPI thresholds is critical.
    Please add this feature ASAP

    Merged Idea (15)