Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I'm working on the Gantt chart based on the matrix table and would like to achive something like that with the colours, so in general from the first date to second I have one colour and then from second to third another one:
At the moment I have a measure that gives me 1 numbers during the whole project, but I was wondering how to divide it into several numbers like: first stage = 1, second stage = 2, then I would be able to dd conditional formatting:
CF Gantt =
VAR StartDate =
CALCULATE (
MIN ( dimE[Epic Start Date] ),
REMOVEFILTERS ( 'dimDate' )
)
VAR GoDate =
CALCULATE (
MIN ( dimE[Epic Go/NoGo Date] ),
REMOVEFILTERS ( 'dimDate' )
)
VAR EndDate =
CALCULATE (
MIN ( dimE[Epic End Date] ),
REMOVEFILTERS ( 'dimDate' )
)
VAR ProjectPeriod =
MIN ( 'dimDate'[Date] ) >= StartDate
&& MIN ( 'dimDate'[Date] ) <= EndDate
VAR Result =
IF (
ISBLANK ( StartDate ),
BLANK (),
IF (
ProjectPeriod,
1
)
)
RETURN
Result
Data model look like this:
Is it even possible?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
83 | |
82 | |
65 | |
49 |
User | Count |
---|---|
135 | |
111 | |
100 | |
65 | |
62 |