save color based on the values
I would like to save the color setting.
lets say CEO as blue, manager as pink... so that i do not need to set the color over and over again when i update the excel files.
If this feature already exists, i would like to know please.
Shakun Grover commented
I am not sure if I understood your question well. Let me know if you think the below suggestion is not applicable to your scenario.
May be try this: Add a numeric column to your data to signify different positions in the organization. Use this column to add color overlays to shapes. So when you update your excel with new data, and then refresh the dataset in Power BI, and refresh your report, overlays would update based on data.