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
I created a matrix table in power bi desktop. In my Rows, I have text 'Tier x', for Tiers 1, 2 and 3. Beneath each Tier is a specific application. I want to change the color of the application name, in the row, to reflect whether or not it is Tier 1, 2 or 3.
My column values are colored - based on conditional formatting. Is there a way to color the fields under the Tiers? For example, Tier 1 apps would be green, Tier 2 apps would be yellow, etc.
I'm still a beginner, but am happy learning 🙂 Thank you for any help!
Solved! Go to Solution.
Hi @niemis
Conditional formatting is functionality that applies only to values and totals.
Furthermore, the headings of rows cannot be separated into different colors.
Alternatively, you can build a measure to give a category, add it to the matrix, and then apply conditional formatting to it.
If this helps the steps you can follow:
1. create measure :
3. Format it based on first level category
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you @Ritaf1983. I don't know that this would work. I may not have explained what I needed very well. Here's a larger screenshot. I need to remove the row sub titles 'Tier x' and I was trying to color code the data underneath those titles. So anything under a Tier 2 row heading would be green, Tier 3 would be yellow, etc.
As you can see I've got conditional formatting on the columns. I'm just baffled at what to do with the rows. Thank you.
Hi @niemis
As I mentioned previously, there is no option to customize the color for row categories.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @niemis
Conditional formatting is functionality that applies only to values and totals.
Furthermore, the headings of rows cannot be separated into different colors.
Alternatively, you can build a measure to give a category, add it to the matrix, and then apply conditional formatting to it.
If this helps the steps you can follow:
1. create measure :
3. Format it based on first level category
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
99 | |
91 | |
82 | |
64 | |
58 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |