Forum Discussion

roger_ha's avatar
roger_ha
Microsoft Employee
7 years ago
Solved

Custom Filters for a Power BI data source

All,  I tried hard to find a solution but I failed. Let me try to explain what I am tryin to do: I am connecting to a Power BI service as a datasource from Power BI desktop. As far as I understand, ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi roger_ha,

     

    You can't direct filter unrelated table records. In my opinion, I'd like to suggest you write a measure to get selected item from slicer, then compare row contents with selected items.

    After these steps, drag it to visual level filters to apply filter on correspond visual.

     

    BTW, live connection will disable most of edit feature so you can't do filter on source data or create filtered calculated table.

     

    Regards,

    Xiaoxin Sheng