Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CastroRibeiro
Helper I
Helper I

Creating a gant chart using a matrix and how to create an event rank

I'm creating a gant chart using a matrix, because I need a certain customization...

 

I'm trying to find a solution for when events have a start and end date on the same day, that is, when they are conflicting

I thought of creating a ranking of the events that are most important.

In my case, if I were to create a rank based on the switch function (code below), it would look like this, in order of importance:

First: 1.8 12.11
Second: 2, 3, 10
Third:6
Room:3
Fifth:5,9,13

 

Today I use conditional customization to fill the cells with colors

Is this the best idea? Is there any better and how can I do it?

 

biDisponibilidade.png

My code:

Periodo = 
var _startDate = 
    CALCULATE(
        MIN('TBL_DISPONIBILIDADE_FROTA_AEREA'[MARCO_INICIAL]),
        ALL(CUSTOM_CALENDARIO)
    )
var _endDate = 
    CALCULATE(
        MAX('TBL_DISPONIBILIDADE_FROTA_AEREA'[MARCO_FINAL]),
        ALL(CUSTOM_CALENDARIO)
    )
var _period = 
    MIN(CUSTOM_CALENDARIO[Data])>= _startDate
    && MAX(CUSTOM_CALENDARIO[Data]) <= _endDate

var _status = 
    CALCULATE(
        MAX(TBL_DISPONIBILIDADE_FROTA_AEREA[STATUS]),
         ALL(CUSTOM_CALENDARIO)
    )


RETURN
SWITCH(
    TRUE()
    ,_period && _status = "INDISPONÍVEL",1
    ,_period && _status = "PREVISTO",2
    ,_period &&  _status = "PRONTO COMUNICADO",3
    ,_period &&  _status = "PRONTO NÃO VALIDADO",4
    ,_period &&  _status = "ENCERRADO",5
    ,_period && _status = "FRANQUIA SOLICITADA",6
    ,_period && _status = "FRANQUIA AUTORIZADA",7
    ,_period && _status = "FRANQUIA EM CURSO",8
    ,_period && _status = "FRANQUIA ENCERRADA",9
    ,_period && _status = "ACC AGENDADO",10
    ,_period && _status = "ACC EM CURSO",11
    ,_period && _status = "ACC ENCERRADO",12 
    )

 

 

0 REPLIES 0

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.