Matrix visual look like a gannt chart

[amalrio]

Hi All, 

I have my data in a tabel format like below(how my back end PowerBI data table look like.

I want to visual that data in a metrix or other sort of visual similar to below.

is there a way that I can achieve this feast. 

[v-lionel-msft · Accepted solution]

Hi,

Please do like this.

1. Create a calculated column.

2. Create a measure.

Color =

VAR x = SUM('Table (2)'[Column])

RETURN

IF(

    x <> BLANK(),

    "#E66C37", "White"

)

3. Create a matrix and set formats.

Best regards,
Lionel Chen

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

[amitchandak]

@amalrio , Create a color measure

measure =countrows(Table)

color measure  = if(not(isblank(countrows(Table))) , "red", "white")

Add a measure to visual in conditional formatting color both background and font using conditional formatting - Field value option

refer step: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[amalrio]

Hi @amitchandak , 

My issue is I get to see below when I do that, I want to achieve my expected outcome, which is not duplicating the facility name. how would you go about it.

[amalrio]

@amitchandak , 

is that something you can achieve or not ??