Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sorting data for multi row card visual

Hello everyone. I'm having some trouble displaying data on a multi row card. My dataset is an SharePoint document that contains 5 columns, one of which is a calculated by dax. Disclaimer: Sch...
Data Protection
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I think you can try If function and add some filter in your code to achieve your goal.

    My Sample:

    We can see in my sample 1s with same "Days On Hold" should return "Refresh Data" for the smallest Order .

    2s should return "Refresh Data" for the smallest "Days On Hold".

    Measure:

    Next Activity =
VAR _COUNT_SCHEDULE_AFTER_TODAY =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Scheduled] ),
        FILTER ( 'Table', 'Table'[Scheduled] > TODAY () )
    )
VAR _ACTIVITY_MAX_ORDER =
    CALCULATE (
        MAX ( 'Table'[Activity] ),
        'Table'[Days On Hold] > 0
            && 'Table'[Order] = MIN ( 'Table'[Order] )
    )
VAR _NEXT_ACTIVITY =
    CALCULATE (
        MIN ( [Activity] ),
        'Table'[Days On Hold] > 0
            && 'Table'[Days On Hold] = MIN ( 'Table'[Days On Hold] )
    )
RETURN
    IF ( _COUNT_SCHEDULE_AFTER_TODAY = 1, _ACTIVITY_MAX_ORDER, _NEXT_ACTIVITY )

    Result 

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mh2587's avatar
mh2587
Super User
4 years ago

Then try visual option to sort by order column

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I'm not using Order Column at the visual and I can't seem to find a way that let me Sort the  activities without applying Order to the visual. Besides, anytime I try to add said column to the visual it shows all of the Activities instead of only the next one.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I think you can try If function and add some filter in your code to achieve your goal.

    My Sample:

    We can see in my sample 1s with same "Days On Hold" should return "Refresh Data" for the smallest Order .

    2s should return "Refresh Data" for the smallest "Days On Hold".

    Measure:

    Next Activity =
VAR _COUNT_SCHEDULE_AFTER_TODAY =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Scheduled] ),
        FILTER ( 'Table', 'Table'[Scheduled] > TODAY () )
    )
VAR _ACTIVITY_MAX_ORDER =
    CALCULATE (
        MAX ( 'Table'[Activity] ),
        'Table'[Days On Hold] > 0
            && 'Table'[Order] = MIN ( 'Table'[Order] )
    )
VAR _NEXT_ACTIVITY =
    CALCULATE (
        MIN ( [Activity] ),
        'Table'[Days On Hold] > 0
            && 'Table'[Days On Hold] = MIN ( 'Table'[Days On Hold] )
    )
RETURN
    IF ( _COUNT_SCHEDULE_AFTER_TODAY = 1, _ACTIVITY_MAX_ORDER, _NEXT_ACTIVITY )

    Result 

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.