I have an inquiry regarding setting up a logic in Power BI that allows users to select colours based on Excel input data, affecting the colour of column headers in a dynamic fashion. The idea is for the system to recognise numerical inputs - with '1' representing green, '2' signifying blue, and '3' indicating red - and to modify the column header colour accordingly. The dataset is updated on a monthly basis, which calls for a logic where changes made in Excel are seamlessly integrated and mirrored in Power BI. My focus is solely on columns, as my column tables don't include rows. Despite the unique nature of this user requirement, which has kept me puzzled for nearly a week, I'm reaching out to see if you could provide guidance or solution. Thanks
You cannot ‘conditionally’ change the color of the column. However you can change the header color of a particular column. I’m assuming your columns do not change in the table. For example if your column name is ‘1’ you can change the header color to ‘Green’ for this particular column. Hope it helps
I have an inquiry regarding setting up a logic in Power BI that allows users to select colours based on Excel input data, affecting the colour of column headers in a dynamic fashion. The idea is for the system to recognise numerical inputs - with '1' representing green, '2' signifying blue, and '3' indicating red - and to modify the column header colour accordingly. The dataset is updated on a monthly basis, which calls for a logic where changes made in Excel are seamlessly integrated and mirrored in Power BI. My focus is solely on columns, as my column tables don't include rows. Despite the unique nature of this user requirement, which has kept me puzzled for nearly a week, I'm reaching out to see if you could provide guidance or solution. Thanks
You cannot ‘conditionally’ change the color of the column. However you can change the header color of a particular column. I’m assuming your columns do not change in the table. For example if your column name is ‘1’ you can change the header color to ‘Green’ for this particular column. Hope it helps