Forum Discussion

Kayla2020's avatar
Kayla2020
Frequent Visitor
1 year ago
Solved

Dynamic Ranking

I'm trying to recreate in Power BI a weekly project ranking matrix that mimics the Excel table below. The goal is to show project data ranked by amount per calendar week with each matrix cell display...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi Kayla2020 ,

    Thanks for reaching out on the Fabric Community. Would you mind sharing a sample of your dataset. That would really help us better understand the issue you're facing sometimes it's easier to troubleshoot with actual data rather than just an image reference.

     

     

    I hope you understand.

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
1 year ago

Hello Kayla2020 

Replace This 

VAR Project = SELECTEDVALUE(tbl[ProjectName])

With this

VAR ProjectList =

    CONCATENATEX(

        FILTER(

            ALL(tbl),

            tbl[WeekNum] = SelectedWeek &&

            tbl[Actual_Amt] = SelectedAmt &&

            tbl[Region] = SelectedRegion &&

            tbl[PM] = SelectedPM

        ),

        tbl[ProjectName],

        ", "

    )

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.