The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all, I need to add a simple table with the information below...doesn't need to be linked to other vizualizations if not possible but I need the Headers with different colours in the background like below. Any suggestion? I have tried the table and matrix from PBI but can't format of conditional format the headers only.
Solved! Go to Solution.
Hi @CMSINFO ,
As you refer you cannot setup conditional formatting to a column header however you can do two things:
Based on this two things you can do a workaroud:
CAT A = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "A") CAT B = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "B") CAT C = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "C")
As you can see you have headers with different colours and the values of the tables are the same.
You can also use the other conditional formatting options as color scale or field value just be sure to add one line for the "normal" values that are to be in black colour.
So although the Condittional formatting is not actually on the headers it looks like it is.
See attach PBIX file.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @CMSINFO ,
As you refer you cannot setup conditional formatting to a column header however you can do two things:
Based on this two things you can do a workaroud:
CAT A = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "A") CAT B = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "B") CAT C = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "C")
As you can see you have headers with different colours and the values of the tables are the same.
You can also use the other conditional formatting options as color scale or field value just be sure to add one line for the "normal" values that are to be in black colour.
So although the Condittional formatting is not actually on the headers it looks like it is.
See attach PBIX file.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, This method is not possible for Matrix visual I guess.
Any alternative for Matrix ?
Thanks IN advance!
This is for the matrix visualization
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix ,
Got it. But my requirement is almost similiar but in the column level I have 2 hirerachies.
Is it possible to attain the color headers for the In-Program & Pre-Program ?
Pbix file link
Thanks in advance!
Hi @MFelix ,
Wanted to color the headers for the below highlighted at 2 column layers.
Thanks1
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
99 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |