Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
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
)
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |