Barchart Color Issue - Field Parameters

[newpbiuser01]

Hello,

I have a stacked bar chart showing the sales by each employee. I am using Field parameters to allow the user to slice the data by either Location or Team. I also have a third option that essentially is a blank fixed color column to show the overall bar chart without any color breakdown ( Fixed Color Column= "")

so I have, 

Parameter = {

    ("Location", NAMEOF('Table1'[Location]), 0),

    ("Location", NAMEOF('Table1'[Team]), 1),

    ("Fixed Color Column",NAMEOF('Table1'[Fixed Color Column]) , 2)

}

I then have a slicer on the page to allow a user to choose between these three options. The first two work no problem and I'm able to define the color palette for the different locations/teams. however, when I choose the Fixed Color Column, I get this default orange color picked for me and even if I choose the "All" option under Categories and try to change the color, it wont change the color. 

Why can't I change the fixed color from the default orange? I dont even have this color in the theme of the report, so I'm not sure why this is happening. 

I'd really appreciate any help!

[Anonymous]

Hi @newpbiuser01,

Have you add any table field to the visual legends field to group records? If that is the case, it means your data bar colors will be managed and assign by visual itself based on the current theme data color array list settings.

BTW, you can also manually modify each item color on the bar panel detail options:

Regards,

Xiaoxin Sheng

[newpbiuser01]

Hi @Anonymous ,

What is the table field? I have used the field parameters to refer to columns in the table, but that's it. Also, I haven't used that orange color anywhere in my report, how do I reset it to use a standard color? I'm able to pick colors for the other parameters, why not the dummy fixed value?

 {

    ("Location", NAMEOF('Table1'[Location]), 0),

    ("Location", NAMEOF('Table1'[Team]), 1),

    ("Fixed Color Column",NAMEOF('Table1'[Fixed Color Column]) , 2)

}

I really appreciate your help and insight! thank you!

[Anonymous · Accepted solution]

HI @newpbiuser01,

The 'Table field' mean the columns that you used on the visual. These data bars colors are grouped by legends field value that you used, and the default color is based on theme datacolor settings.
If you do not want colored these bars as orange, you can tried to modify the theme datacolor settings:

Use report themes in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng