Filtering Matrix visual.

[srana]

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 columns.

All the field for the columns and slicers is coming from one table.

[Anonymous]

Hi @srana,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi @Anonymous ,

I am replying on behalf of @srana .

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]

@srana , 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]) )