Cross filter function not working for multiple visual.

[Yagevendra]

Hello,

I have 2 Dim table and 1 fact table, And I have created 2 measures for 2 different visual.

I am trying to add Cross filter function for both visual ones i put the both measure in a filters pane visual level filter the data releted to 2nd visual not show me on 2nd filter when i select 1st filter. 

Instead i used both direction relationship

I would show me filter for both visual.

I want the output like both direction 

Need help.

[v-rzhou-msft]

Hi @Yagevendra 

I know you have two visuals, and you build two measures to filter these two visuals. Did you build relationships between Dim table and your Fact table? Could you share a sample with us? I couldn't understand your requirement from your statement. What kind of the result did you want? You can show me a screenshot with the requirement you want. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yagevendra]

@v-rzhou-msft ,

My requirement is I want to show my required filter in a filter selection window for related visual
so when I use both directional relationship it would working fine but when I use cross filter for different
measure and put a both measure in a filter pane visual level filter it shown me only blank.

So I was investigating the some reason may be cross filter work when i select one filter value from 1st filter then check another filter selection window it would be show only both visual related data in a filter

I have one or 2 string value in a filter 1 these is related only to 2nd visual when I select this value from filter 1st the 2nd filter wouldn’t show me the related value

here is my sample data.

Date	Filter 1	Filter 2	Filter 3	Filter 4	Metric	Graph name	value
1	1	102	101	1	A	PP	1
2	1	102	102	2	B	TT	2
3	1	103	103	3	C	TT	1
1	2	102	102	1	D	TT	1
2	2	103	103	2	A	TT	1
3	2	101	101	3	B	PP	2
4	2	105	105	4	C	PP	2
1	3	101	101	1	D	PP	1
2	3	103	103	2	C	PP	2
2	3	104	104	3	B	TT	1
4	3	105	105	4	B	PP	1
5	3	102	102	2	C	TT	2
7	3	106	106	4	D	PP	1
7	3	107	107	2	C	TT	2
8	4	108	108	1	D	TT	1
8	4	101	101	3	D	TT	2
1	1	101	101	1	A	PP	1
2	1	102	102	2	B	TT	2
3	1	103	103	3	C	TT	1
1	2	102	102	1	D	TT	1
2	2	103	103	2	A	TT	1
3	2	101	101	3	B	PP	2
4	2	105	105	4	C	PP	2
1	3	101	101	1	D	PP	1
2	3	103	103	2	C	PP	2
2	3	104	104	3	B	TT	1
4	3	105	105	4	B	PP	1
5	3	102	102	2	C	TT	2
7	3	106	106	4	D	PP	1
7	3	107	107	2	C	TT	2
8	8	108	108	1	D	TT	1
8	8	101	101	3	D	TT	2

Filter files.

Filter 1	Name
1	Hotstar
2	Prime
3	BBC
4	Netflix
8	Star

Filter 2	Name
101	A
102	B
103	C
105	D
104	E
106	F
107	G
108	H

Filter 3	Name
101
102
103
105
104
106
107
108

Filter 4	Name
1	TV
2	Tablet
3	PC
4	Mobile

Expected result

Current result

[PaulDBrown]

If you are trying to get the slicers to crossfilter, you can use the following as a filter in the filter pane of each slicer, setting the value to "greater or equal to 1":

Filter Slicers =
COUNTROWS ( RELATEDTABLE ( Data ) )

[v-rzhou-msft]

Hi @Yagevendra 

I see in your Minute measure, you calculate the sum of value in Data(2) table. I couldn't find Data(2) in your Sample. You add Minute measure and Reach measure into Filter 2 as filters. The slicer will show values if item in Minute measure and Reach measure is not blank. So Filter 2 show blank should be caused by measure filters. Minute measure or Reach measure may return blank based on your code logic. Please check your measures.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yagevendra]

@v-rzhou-msft Sorry i posted wrong measure ss
its basically from data 1 table and i double checked i put a both measure in a filter 2 visual level and select no blank value from the drop down.
i investigated same filter values are displayed which is useful for both chart if the value or string not for chart 1 it will not shown in a filter 2 same for chart 2.

Note:- Both directional relationship work perfectly
but i can't use in my model.

[v-rzhou-msft]

Hi @Yagevendra 

My Data model is as below, I think you can use both directional relationship in your data model directly.

My sample works well. You see in the table visual Minute will show result in 101 and 108.

I suggest you to build a table visual by "Filter 2" from "Filter 2" Table and [Minute] and [Reach] Measures.

When you select "Filter 1" = 8, at least one of [Minute] or [Reach] may show blank. This will cause "Filter 2" slicer show blank. Both of them shouldn't show blank. 

If this reply still couldn't help you solve your problem, please share a sample file with me.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yagevendra]

@v-rzhou-msft Yes i did the same but the problem is that i have one new fact table and i can not join with this fact table to all dim table with both directional relationship.

[PaulDBrown]

Can you post sample data or a link to a PBIX file theough OneDrive, Google Drive, Dropbox...? And a depiction of the expected outcome (recreate in Excel for example)