Hi All,
Hope you all are good . Iam facing a issue in Power Bi, for which i need your help. I have a Member Table which will have Member id, and RIsk Status Table which will have member id, Risk Id, Risk Description.
My Requirement is to show highest risk for each member based on Date slicer selection in Table. for ex: A member may fall into different Risk in Different Time frames. So, for a selected time frame for a member i need to show highest risk . This is achievable , but issue is , when a member is having highest Risk as "Medium" in one timeframe, i can see other Risk values also in slicer and when i select when i select that other risk , Risk column in table is blank, but still i can see member id .
Let me know if there is any way, when i select other category in slicer, table visual should go blank. ( i did this using filter pane, but facing Performance issues).
Please help!
TIA
