Power BI 内置视觉对象实现蛇形S形时间轴图表

M.DateIndex = 
VAR _Columns = 4 --定义显示多少列
VAR DateRank =
    ROWNUMBER ( ALLSELECTED ( '日期表'[Date] ), ORDERBY ( [Date], ASC ) )
VAR GroupNumber =
    INT ( ( DateRank - 1 ) / _Columns )
VAR PositionInGroup =
    MOD ( DateRank - 1, _Columns ) + 1
RETURN
    IF (
        MOD ( GroupNumber, 2 ) = 1,
        GroupNumber * _Columns + ( _Columns - PositionInGroup + 1 ),
        GroupNumber * _Columns + PositionInGroup
    )

SVG.S.4 = 
VAR _Columns = 4 --定义显示多少列
VAR _Rows =
    ROUNDUP ( COUNTROWS ( ALLSELECTED ( '日期表'[Date] ) ) / _Columns, 0 )
VAR DateRank =
    ROWNUMBER ( ALLSELECTED ( '日期表'[Date] ), ORDERBY ( [Date], ASC ) )
VAR PositionInGroup =
    MOD ( DateRank - 1, _Columns ) + 1
VAR GroupNumber =
    INT ( ( DateRank - 1 ) / _Columns )
VAR _PathY =
    SWITCH (
        TRUE (),
        GroupNumber < _Rows - 1
            && PositionInGroup = _Columns, "M100 15 100 30",
        GroupNumber > 0
            && PositionInGroup = 1, "M100 15 100 0"
    )
VAR _PathX =
    SWITCH (
        PositionInGroup,
        1, IF ( MOD ( GroupNumber, 2 ) = 0, "M100 15L200 15", "M0 15L100 15" ),
        _Columns, IF ( MOD ( GroupNumber, 2 ) = 0, "M100 15L0 15", "M100 15L200 15" ),
        "M0 15L200 15"
    )
RETURN
"data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' id='wujunmin' width='200' height='30'>
    <path d='" & _PathX & _PathY & "' stroke='lightgrey' stroke-width='1' stroke-dasharray='2' fill='none'/>
    <rect rx='2.5' x='97.5' y='12.5' height='5' width='5'  fill='deepskyblue'/>
    <!--公众号:wujunmin-->
</svg>"