Forum Discussion
Filtering Matrix visual.
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.
Hi Anonymous,
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
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.