Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
215 | |
89 | |
76 | |
66 | |
60 |