Relational Slicers

[Anonymous]

Hi guys,

In my report i have some slicers. Requirment is that when i select any value in one slicer, then all other slicers having related data to selection should get afested and display their data.

Explained with Screenshots below: Empty all

On selecting a value in mgmt lvl 5

[Mariusz]

Hi @Anonymous 

If the slicers are coming from the same dimension then it should happen by default, if that's not the case then you can create a measure like 

filter = INT( NOT ISEMPTY( 'fact table' ) ) 

and use it as a visual filter where the condition is = 1 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

@Mariusz  let me know what do you mean by same dimension here?

[Anonymous]

@Mariusz  To which slicer do i need to apply this measure as the scenario should apply to selection in all slicers

[Mariusz]

Hi @Anonymous 

All slicers,

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

@Mariusz  i have around 25-30 slicers in my page with small alignments placed side by side. Is there anyway to create a measure and apply to  all slicers.

Also i tried to contact you in Linkedin.

[Mariusz]

Hi @Anonymous 

Well, the second option is what @adambhappy  suggested, but it's not the best option as suggested in the article below. 

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[adambhappy]

You can enable bi-direcational filtering between your fact and dimension tables, this will give the same result but there are drawbacks.

See: https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

[adambhappy]

Can you post a screenshot of your relationship view? Much easier to answer your question that way.

[Anonymous]

[Mariusz]

Hi @Anonymous 

Columns coming from the same Table ( Dimension ), basically a lookup table with attributes for example ( city, state, country ) that is used to filter transaction table ( Facts ).

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.