Forum Discussion

ja_02's avatar
ja_02
New Member
1 year ago
Solved

Filter between 2 visual tables from the same data source

Hi, I have a Task table for the datasource in PowerBI dashboard. This can be an example for Task table structure and data: ID Category Type 1   1   Main 2   1   Sub 3   2   Main 4   2   Main ...
Need Help
Show and Tell
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi ja_02,
    Thank you for reaching out to the Microsoft fabric community forum. Thank you pankajnamekar25, for your inputs on this issue.

    After thoroughly reviewing the details you provided, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome:

     


    I am also including .pbix file for your better understanding, please have a look into it:

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

    Thank you for using Microsoft Community Forum.

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello ja_02 

 

Follow this steps

Use a Disconnected Category Table to Filter by Category Only

Create a new disconnected table:

CategoryFilter = DISTINCT(SELECTCOLUMNS('Task', "Category", 'Task'[Category]))

Create a measure to check category match

IsCategorySelected =

VAR SelectedCategory = SELECTEDVALUE(CategoryFilter[Category])

RETURN IF(SelectedCategory = 'Task'[Category], 1, 0)

Apply filters on visuals:

Visual #1 Filter Type = Main and IsCategorySelected = 1

Visual #2 Filter Type = Sub and IsCategorySelected = 1

Use CategoryFilter as a slicer or visual to control both tables.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.