Table with display several degrees of display

[MathieuF]

Good morning,

I have data corresponding to 14 indicators.

These indicators, I want to display them per agent (a single agent selected via a filter segment) but also in a 2nd column display the indicators of his team, and in the 3rd column the indicators of his domain. You should know that the agents are all in teams, and each team has its own problem area.

I have a table that links agents to teams, to domains. On the image below, I would like to have the team in red and the domain in green.

How to do ?

Thanks for your help.

[MathieuF]

Hello,
I still have the problem.
Can you help me ?
Here are test files. https://drive.google.com/drive/folders/1I5lTo3STJ6yNOtRXS3QIq25pu0elodlu?usp=sharing
Thank you so much

[Anonymous]

Hi @MathieuF ,

Due to its design, power bi desktop does not currently support customizing the color of different column headings, you can only standardize the color of column headings.

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

But you can customize the background color of the column data, first we create two metrics and then set the conditional format for the columns, the result is shown in the figure below.

(1) This is my test data. 

(2) We can create two measures. 

team_color = "red" 

domain_color = "green" 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[MathieuF]

Hello @Anonymous ,
Thank you very much for your feedback.
Excuse me, I think we misunderstood.
I mentioned the color blue and the color red to just represent the columns.
I actually want to have 1 Agent column, the 2nd Team column and the 3rd skill column.

Finally, I left on another idea, but I have a problem...
In fact, my measurement I declined it in 3 measurements, one for the agent, one for the team and a last for the competence.
Then after, I made a measurement to group the 3.
However, and I won't explain it, the agent measure works, the skill measure works but the team does not...

1. NEW interactions acceptées/h (Agent) = 
FORMAT(
        DIVIDE(
            CALCULATE(
                DISTINCTCOUNT(Journal[id]),
                Journal[name] = "task.taken",
                ALL(Equipe[Equipe], Equipe[Compétence])
            ),
            CALCULATE(
                SUM(Presence_Time[presence]),
                ALL(Equipe[Equipe], Equipe[Compétence])
            )
        ) * 3600,
        "#,0.0"
    )

1. NEW interactions acceptées/h (Compétence) = 
FORMAT(
        DIVIDE(
            CALCULATE(
                DISTINCTCOUNT(Journal[id]),
                Journal[name] = "task.taken",
                ALL(Equipe[Agent], Equipe[Equipe])
            ),
            CALCULATE(
                SUM(Presence_Time[presence]),
                ALL(Equipe[Agent], Equipe[Equipe])
            )
        ) * 3600,
        "#,0.0"
    )

Team :

1. NEW interactions acceptées/h (Equipe) = 
FORMAT(
        DIVIDE(
            CALCULATE(
                DISTINCTCOUNT(Journal[id]),
                Journal[name] = "task.taken",
                ALL(Equipe[Agent], Equipe[Compétence])
            ),
            CALCULATE(
                SUM(Presence_Time[presence]),
                ALL(Equipe[Agent], Equipe[Compétence])
            )
        ) * 3600,
        "#,0.0"
    )

1. NEW interactions acceptées/h (Formatage) = 
    "A" & [1. NEW interactions acceptées/h (Agent)] &
    " E" & [1. NEW interactions acceptées/h (Equipe)] &
    " C" & [1. NEW interactions acceptées/h (Compétence)]

If you have an idea I'm a taker.

I do have a table that includes agent, team and skill.
Mathieu