Forum Discussion

EshaanG's avatar
EshaanG
Helper I
6 years ago

How to dynamically filter a table in PowerBI

I have a table in a data model which is like this :   PersonID   ProgramID   Status 1                P1                Completed 2                P2                Completed 3                   ...
Need Help
EshaanG's avatar
EshaanG
Helper I
6 years ago

Hello v-easonf-msft

 

Thanks for the solution. It works pretty much fine in my actual data but somehow some the program column shows random values even though the final status and row count is accurate!

Shall I send a .pbix for you to have a look

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , EshaanG 

Please tell me more details.You can upload the expected results or screenshots  .

It will make it easier for me to understand your question if you can make a sample/ or share your pbix file without any sensitive data to me .

 

Best Regards,
Community Support Team _ Eason

  • EshaanG's avatar
    EshaanG
    Helper I
    6 years ago

    Hello, 

     

    The sample .pbix is attached for your reference. If you see the screenshot below then if I select a Course then something else shows up in the table. Any help will be appreciated