Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am curious on how to format the table in order to catch the attention of the user that each 3 of these columns are somewhat related. Reason I am asking becasue the table has quite a few columns and would like to catch their attention without overwelming them with colors. Example attached (of course this doesnt look good but just trying to illustrate)
Thanks
Solved! Go to Solution.
Hi @stribor45 ,
Thanks for using Microsoft Fabric Community,
To achieve your requirement of grouping related columns with same colours to make the user easily distinguish in Power BI -- the steps suggested by @ToddChitt are valid and can help achieve your needs.
Here is the illustration of the steps in Power BI Desktop.
1. Populate your table visual with columns and click on Format visual in the Visualisation pane . Here you can find 'Specific column' as shown below.
2. Next select column to apply settings and enable Apply to header option if required, then select background or text colour according to your needs.
3. Choose light colours to make the values visible and distinguish clearly.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
Hi @stribor45 ,
Thanks for using Microsoft Fabric Community,
To achieve your requirement of grouping related columns with same colours to make the user easily distinguish in Power BI -- the steps suggested by @ToddChitt are valid and can help achieve your needs.
Here is the illustration of the steps in Power BI Desktop.
1. Populate your table visual with columns and click on Format visual in the Visualisation pane . Here you can find 'Specific column' as shown below.
2. Next select column to apply settings and enable Apply to header option if required, then select background or text colour according to your needs.
3. Choose light colours to make the values visible and distinguish clearly.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
If I understand correctly, you want to set the background color of two or more columns to be the same color. Other groups will have different colors.
You can do that in the Format menu of the table. Look for a setting called "Specific column", then select each column in turn and set the background color accordingly. Looks like you will also want to select the "Apply to header" option.
Proud to be a Super User! | |
Thanks . I will take a look. Worry that might be too much color. Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
43 | |
40 |