Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering Matrix visual.

I have a matrix visual which has 3 columns and 3 slicers to filter the matrix table as shown below:-    Each column should be filtered out by its respective slicers and should not affect other...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    I am replying on behalf of Anonymous .

    Attached is the sample pbix file which is used here.

    Here is the situation -

    I have two tables i.e is DATA_1 & DATA_2 which has Field, region, version, hop & counts columns.

    In transform data, I have applied pivot step so that hop_name can get the counts respectively.

    After that, I append both the tables. 

    On report side, I need three slicers - one is for Region, version_for_Hop1 and version_for_Hop2 (This is all coming from append table)

    I took table visual to show the fields and hops.
    This is how it looks like -

    The problem is - 

    When I select V1 from version_for_Hop1 and V4 or any other items from version_for_Hop2 , the table turns out blank.

    Expected Result is- 

    When I select V1 From version_for_Hop1 and V4 from version_for_Hop2, it should show respective data in each columns.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You have to create measures to use the values from these slicers and ignore from others

If they are same or joined table- means filter when select then create like

 

calculate(Sum(Table[Value), removefilterS(Table[Version_V2]), removefilterS(Table[Version_V3]) )

 

if they are independent slicer then try measure like

calculate(Sum(Table[Value),filter(Table, Table[Version_v1] in values(Version1[Version_V1]) )