Filter values of one filter by selecting values in another filter

[acekalina]

Hi,

I am using Live connection to a Tabular data model, and I would like to implement the following logic:

- There are two columns based that are used in Filters section. Let's say 'Filter 1' and 'Filter 2'.

- I want to make 'Filter 1' to be dependent on 'Filter 2' selections:

• If nothing is selected in 'Filter 2', nothing should be displayed in the 'Filter 1'.
• If at least one value is selected in 'Filter 2', all values from 'Filter 1' should be available for user to select.

This logic is required to make sure user is not using 'Filter 1' without at first filtering out values using 'Filter 2'.

[Mariusz]

Hi @acekalina 

You can create a Measure like below and later use it as a filter in slicer visual.

Measure = INT( ISFILTERED( 'Table'[Filter1] ) )

When the is any filters applied to Column Filter1 then Filer2 slicer will display corresponding Values, however, if there are no filters applied to Column Filter1 then Filer2 slicer will display no selections.

Please see the attached file for reference.

Best Regards,
Mariusz

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

[acekalina]

Hi @Mariusz ,

Thank you for your quick response. I have tries your solution, but it works only on slicers. However, I need this solution on filters that are used in the Filters section. Any idea how to do that?

[Mariusz]

Hi @acekalina 

Sorry don't think it's possible to apply it to filters, you can switch of filter pane and use slicers instead ( not the best workaround but the only possible at the moment )

Best Regards,
Mariusz

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

[acekalina]

@Mariusz 

Thank you for confirming.

Maybe you could also confirm if it is possible to create hierarchy on data coming from Live connection to tabular data model?

So for our example group like below:

[Mariusz · Accepted solution]

Hi @acekalina 

Sorry, can't test it as I have no connection to live AS instance or azure AS model at the moment, you can try yourself and if it's not working you can always build the hierarchies is AS Tabular

Best Regards,
Mariusz

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