How to get a slicer propagate the chosen value to other slicers ?

[LogiqueNeutre]

Hello,

I have several slicers pointing to different tables, but each of these tables is a copy of the "same" data.

I would like to simply have my users able to select, in a given visual, one or several values in a slicer, and have these values also ticked for the other slicers (they may be hidden for example).

Synchronizing the slicers by putting the same group name doesn't work because they are not from the same table.

I had the idea to create another table, and have it pointing to the others in a 1-* relationship, but it still is refused for circular references problems, so this doesn't work neither.

I'm trying to see if i can use inactive relationships and USERELATIONSHIP() but it works for measures, and here my use is larger than just measures, i'm trying to have users filter data the way they want...

Any idea, any help is welcome.

Thank you for reading.

[PaulDBrown]

You can use a measure such as:

FILTER = 
COUNTROWS(
    INTERSECT(VALUES('Table 1'[D colum 1]),
    INTERSECT(
        VALUES('Table 2'[D colum 2]), VALUES('Table 3'[D Column  3]))))

to filter the values in the other slicers. Add the measure to the filter pane for each visual and set the value to 1

 Here is the link to the sample file

https://1drv.ms/u/s!AhGKDZz6e4HehLFOQtVAFqEEAuXtqA?e=TuU9VS 

[LogiqueNeutre]

Hello,

thank you for your answers.

So this is half a solution : it would effectively reduce the search time for the end users, but not fully automate the actions since they still have to click in both slicers GD2 and GD3. Thank you for that saved time !

Also, would my idea of using an inactive relationship be a wrong lead then ?

[PaulDBrown · Accepted solution]

"but not fully automate the actions since they still have to click in both slicers GD2 and GD3"

Sorry, what do you mean? The example illustrates that they can use any of the 3 slicers. They don't have to select values from all 3 slicers. Or am I misunderstanding your request?

EDIT: I see what you mean. Yes, it still requires the user to select the value in the other slicers. To avoid that, you (also) need to apply the FILTER measure to the fact table columns in the visual.

[LogiqueNeutre]

Hello again,

i tried, but even after putting the FILTER measure to a visual, it didn't filter baded on the "master slicer". The user still has to click the filtered slicer on the desired value.

Notice that, when adding the FILTER measure to this visual, it first didn't let me activate it (clicking the "type of filter" list doesn't show the list, preventing me from filtering anything), i had to use another visual, copy-paste it, add the "FILTER measure = 1" filter, then remove other parameters and progressively transforming the copied visual to the desired visual. Even like that i'm not sure it's actually supposed to work.

[LogiqueNeutre]

Hello,

i just tried your solution, and it works. I also am not sure, after all, that it requires clicking the other 2 filters... and i don't understand why......

But in case of a problem in a visual, i'll apply your solution to also put the measure.

Thank you very much for your help !

[Anonymous]

Hi, @LogiqueNeutre 

Can you provide some of the example data, and what you expect the output to be?

Best Regards,

Community Support Team _Charlotte

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

[LogiqueNeutre]

Thank you for your answer.

I have a table GD1 with two columns, G and D. To one value of G there are several of D.
I have tables GD2 and GD3 which are exact copies of GD1.

I have several tables, let's call them T01, T02, ..., T08, with 1-* two-sided relationships between them. GD1 is linked in 1-* one-side relationship only to T01, GD2 the same way to T02, GD3 the same way to T03.

I have a slicer for GD1, permitting to filter by one or several values of G AND D.
I need my report's end users to be able to select values in this slicer, and that it automatically puts the same chosen values in a slicer for GD2 and a slicer for GD3 (which then can be hidden, for example). Otherwise, my end users have to select 3 times the same values in each of the 3 slicers.

Thank you for your help, anyone.

-------------------
|    GD1 slicer      |
-------------------
| G1 >                 |
|    D1                 |
|X D2 (selected) |
|X D3 (selected) |
|   D4                  |
| G2 >                 |
|    D5                 |
|    D6                 |
| G3 >                 |
|    D7                 |
|    D8                 |
|    D9                 |
-------------------

-------------------
|    GD2 slicer      |
-------------------
| G1 >                 |
|    D1                 |
|X D2 (selected) |
|X D3 (selected) |
|   D4                  |
| G2 >                 |
|    D5                 |
|    D6                 |
| G3 >                 |
|    D7                 |
|    D8                 |
|    D9                 |
-------------------

-------------------
|    GD3 slicer      |
-------------------
| G1 >                 |
|    D1                 |
|X D2 (selected) |
|X D3 (selected) |
|   D4                  |
| G2 >                 |
|    D5                 |
|    D6                 |
| G3 >                 |
|    D7                 |
|    D8                 |
|    D9                 |
-------------------

[Anonymous]

Hi, @LogiqueNeutre 

After testing, I'm afraid your needs cannot be realized. Unless the two outer two tables are linked to the GD1 column in a one to one ratio.

Best Regards,

Community Support Team _Charlotte

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