Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sachiko
Frequent Visitor

how to specify colors

 

I would like to specify the color of the graph by importing the theme of the report.

 

Is it possible to specify a color for a particular value in the graph?

Please let me know how to modify the following sample JSON file.

 

{

     "name": "Valentine's Day",

     "dataColors": ["# 990011", "# cc1144", "# ee7799", "#eebbcc", "# cc 4477", "# cc 5555", "# 882222", "# A 30 E 33"],

     "background": "# FFFFFF",

     "foreground": "# ee 7799",

     "tableAccent": "# 990011"

}

 

As for why you want to know such things, I would like to use graph included some companies and specified to colors.

I would like to designate specific colors for the companies of the two designated companies and let other companies automatically assign colors.

Please tell me how to create/modify a JSON file.

 

Thank you.

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @sachiko,

 

>>Is it possible to specify a color for a particular value in the graph?

To be honest, I'm not very familiar with this feature, but I think it is impossible to specify a color for particular value.

 

For similar requirement, I'd like to recommend you take a look at conditional formatting.(notice: this feature only available on some specific visuals)

Conditional Formatting in Power BI

 

 

I'd like to suggest you take a look at following article which mentions custom theme json and properties:

Use Report Themes in Power BI Desktop (Preview)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
sachiko
Frequent Visitor

I would like to specify the color of the graph by importing the theme of the report.

 

Is it possible to specify a color for a particular value in the graph?

Please let me know how to modify the following sample JSON file.

 

{

     "name": "Valentine's Day",

     "dataColors": ["# 990011", "# cc1144", "# ee7799", "#eebbcc", "# cc 4477", "# cc 5555", "# 882222", "# A 30 E 33"],

     "background": "# FFFFFF",

     "foreground": "# ee 7799",

     "tableAccent": "# 990011"

}

 

As for why you want to know such things, I would like to use graph included some companies and specified to colors.

I would like to designate specific colors for the companies of the two designated companies and let other companies automatically assign colors.

Please tell me how to create/modify a JSON file.

 

Thank you.

3.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.