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, ...
Need Help
Tips and Tricks
  • 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

Anonymous's avatar
Anonymous
Not applicable
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

mwegener's avatar
mwegener
Most Valuable Professional
7 years ago

If we answered your question, please mark the post as solution, this will also help others.