How to apply multiple colors on a single cell

Question

Hello experts,Below is the Pivot table view.I have a requirement to show multiple names belong to a type Type1 as shown below.I need to show them in one cell, I am able to achieve using below measure.Name=CONCATENATEX (VALUES(Table[Name]),Table[Name], UNICHAR(10))&nbsp;Now, I need to show the names in different color based on the status column in a single cell. If Status="Risk", then show in Red, if Status="On Track", then show in Orange.For example, example1: for Q1 2021, the status of AA1 is "Risk", so it should be in Red color, whereas the status of BB1 is "On Track", so, it should be in Orange in a single cell.Example2: for Q3 2021, the status of AA5 and BB5 is "Risk", so it should be in Red color in a single cell.&nbsp;How to show different color in single cell?&nbsp;

anonymous · Accepted Answer

Hi&nbsp;anileshknpowerb&nbsp;
In addition to&nbsp;&nbsp;amitchandak&nbsp;'s reply, conditional formatting can not change names in one cell into different colors.
Here I will give you some advice. Firstly split your names into different cells.
Data model.

Then group all rows by Qtr column and add an index column by M code in Power Query Editor.&nbsp;
...
Indexed = Table.TransformColumns(#"Grouped Rows", {{"Rows", each Table.AddIndexColumn(_,"GroupIndex", 1, 1)}}),
...
Expand table:

Whole Code in Advanced Editor:
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCqksSDVU0lFydASRgYYKRgZGIJahAZAIyizOVorVQahycsKiyj9PIaQoMRlVpaOjMUilEWGVTk5YVGLY7OhoClJlTMh9xKhydDQCqTIhZBYWVQgfxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Type = _t, Name = _t, Qtr = _t, Revenue = _t, Status = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Type", type text}, {"Name", type text}, {"Qtr", type text}, {"Revenue", Int64.Type}, {"Status", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Qtr"}, {{"Rows", each _, type table [Type=nullable text, Name=nullable text, Qtr=nullable text, Revenue=nullable number, Status=nullable text]}}),
    Indexed = Table.TransformColumns(#"Grouped Rows", {{"Rows", each Table.AddIndexColumn(_,"GroupIndex", 1, 1)}}),
    #"Removed Columns" = Table.RemoveColumns(Indexed,{"Qtr"}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Removed Columns", "Rows", {"Type", "Name", "Qtr", "Revenue", "Status", "GroupIndex"}, {"Rows.Type", "Rows.Name", "Rows.Qtr", "Rows.Revenue", "Rows.Status", "Rows.GroupIndex"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Rows",{{"Rows.Type", "Type"}, {"Rows.Name", "Name"}, {"Rows.Qtr", "Qtr"}, {"Rows.Revenue", "Revenue"}, {"Rows.Status", "Status"}, {"Rows.GroupIndex", "GroupIndex"}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Name", type text}, {"Type", type text}, {"Qtr", type text}, {"Revenue", Int64.Type}, {"Status", type text}, {"GroupIndex", Int64.Type}})
in
    #"Changed Type1"
Then build a matrix, create a color measure and use conditional formatting on Name column.
Name color field = IF(MAX('Sample'[Status]) = "Risk","Red","Orange")

Result is as below.

Best Regards,
Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

Forum Discussion

How to apply multiple colors on a single cell

2 Replies

Related content

multiple or single semantic model

Attach multiple lakehouse to a single notebook.

Single master PBI report for multiple clients

Single Legend for multiple visuals?

Multiple Color bubbles in a single map