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
Hello,
Is it possible to color lines of a table visualisation to distinguish category.
The rule would be "color the lines of the same category with a random color"
We find the category in a column but it can change at every refresh of the database.
I've already ordered by category but it's not clear enough that they are grouped together
Thank you for your help
@PhilCh , I am not sure about line, but you should be able color background using color measure and conditional background formatting
example
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)
use in conditional formatting using field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
Hello @amitchandak ,
Thank you for trying to help me.
First when I go to conditional background formatting using field value I have the windows below, not a field for DAX.
Second, I m not sure I understund your code as I told you I don't know the categories and how many they are, it changes at every refhresh of the database.
I can only specify I want a different color for every distinct category
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 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |