Forum Discussion

RoxanaZaharia's avatar
2 years ago
Solved

a better method to solve this

Hi! I'm fairly new to using Power BI. So I downloaded this data set from kaggle: https://www.kaggle.com/datasets/krishd123/olympics-legacy-1896-2020 , and i am trying to show the gold winners and the...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi RoxanaZaharia ,

     

    If you don't want to show up in a visual, you can create a table.

    Table = SELECTCOLUMNS( FILTER('all_athlete_games',[Sport]="Basketball" && [Season]="Summer" && [Medal]="Gold"),"Name",[Name],"Event",[Event],"Year",[Year])

    If you don't want to filter using the filter pane, you can create a slicer.

    Slicers in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Neeko Tang

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