Forum Discussion

DouglasBrito's avatar
DouglasBrito
Helper I
4 years ago
Solved

Conditional Data Color Formatting Bar by field values

Hi Guys,   I'm wondering if it is possible to achieve what I'm looking for.   I have a fish quantity dataset through various years, if use [fish qty] as Values with [year] as Axis and [fish name]...
  • v-angzheng-msft's avatar
    4 years ago

    Hi, DouglasBrito 

     

    Thanks for the explanation.
    What you want to do is to keep the color of the data bars constant in all cases.

     

    The inelegant way to do this is to manually adjust the color of each visual data bar.


    You can also import a custom theme to do this. With custom themes you can customize the color of multiple visual data bars at the same time.
    By default, the visuals have their own color groups. If you find inconsistent data bar colors on multiple visuals, it may be that the default colors of different visuals do not match. Or a different theme was applied.

     

    Refer to this document to learn more about custom report themes

    Use report themes in Power BI Desktop

    You can also make further adjustments to the theme you just imported on your desktop after importing it.

     

    Here is website to help you quickly generate json files for custom themes.

    https://themes.powerbi.tips/properties

     

    I provide a sample theme below, you can modify it or generate a new theme yourself.

    Please refer to the attachment below for details. 

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.