Forum Discussion
Data colors based on another field values
I am pretty new to POWER BI. I have the below chart in Tableau and am trying to replicate this on to POWER BI. But not finding the option.
I have two Charts - Category and count of tickets, Subcategory and count of tickets. In Tableau I created a chart for Subcategory and simply drag-drop the Category field to color control. Which will give me the Subcategory bars coloured based on their respective Categry values. But struggling to find this option in POWER BI. Do we have this option in POWER BI ?
If you look at the "EUSR Provisioning" in the first chart, we have to subcategories underneath it which is Provision and Deprovision. Now the same color is applied in the second chart. I have this in Tableau but not sure on how to do this in POWER BI
Anonymous
Hi, look the PBIX. with Conditional formatting you can create a measure and assign a color to each category (Yes, you need to know all the categories).
ColorFormat = SWITCH ( SELECTEDVALUE ( Table1[Category] ), "A"; "#000000", "B"; "#ff0000", "C"; "#ffa500", "D"; "#551a8b", "E"; "#98fb98" )A sample is attached.
Regards
Victor
12 Replies
Hi Anonymous,
I think conditional formatting feature will suitable for your requirement, but current it seems only works on table and matrix visuals.
Conditional formatting in tables
Maybe you can submit an idea for add support for more visuals.
Regards,
Xiaoxin Sheng
Anonymous
Hi, In a direct way (with a drag and drop or selecting an option) is not possible for the moment.
Regards
Victor
Anonymous
Hi, look the PBIX. with Conditional formatting you can create a measure and assign a color to each category (Yes, you need to know all the categories).
ColorFormat = SWITCH ( SELECTEDVALUE ( Table1[Category] ), "A"; "#000000", "B"; "#ff0000", "C"; "#ffa500", "D"; "#551a8b", "E"; "#98fb98" )A sample is attached.
Regards
Victor
Same here, I have the category colors in a database table and I'd like to use it in PBI visuals.
Any help achieving this would be great.
