Filtering a slicer to choose different columns

[NiallMaths]

Hi 

I am trying to create a page where the user can compare land use in different local authorities or they can compare land use in different regions.

The data is currently in format where each row is:

Local Authority, Region, Country, Land Use type, Area

I want to have a slicer where the user can decide whether they want to compare regions to one another, or local authorities.

Then a second slicer, which if the user has chosen region, will show the regions from which they can choose a few

Then a bar chart below will compare the chosen values from the second slicer.

 Would anyone be able to help with this?

Thanks

[kentyler · Accepted solution]

I don't think you can dynamically change one slicer based on another slicer

In this examples the slicers come from the columns in the table

so the user can chose from either slicer, without having to first chose between region and local authority

you can create a measure that looks to see which slicer has a value selected and then develops a different total depending on the selection...the result of that measure would be dynamic and you could use the measure as the value in a bar chart.
you would have to decide how you wanted to handle the situation if the user made a selection in both slicers... you can use a card that displays the contents returned by a measure. the card's measure would have similar logic to the measure supplying the value for your bar chart, normally it would display the value selected, if 2 values were selected it would display a message saying "please select just one value"

let me know if you need help with the DAX for those measures.

[v-lili6-msft · Accepted solution]

hi  @NiallMaths 

To my knowledge, it could not achieve in power bi for now.

As a workaround, I would suggest you use bookmark to set different bookmark for "first slicer".

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Regards,

Lin

[kentyler · Accepted solution]

I don't think you can dynamically change one slicer based on another slicer

In this examples the slicers come from the columns in the table

so the user can chose from either slicer, without having to first chose between region and local authority

you can create a measure that looks to see which slicer has a value selected and then develops a different total depending on the selection...the result of that measure would be dynamic and you could use the measure as the value in a bar chart.
you would have to decide how you wanted to handle the situation if the user made a selection in both slicers... you can use a card that displays the contents returned by a measure. the card's measure would have similar logic to the measure supplying the value for your bar chart, normally it would display the value selected, if 2 values were selected it would display a message saying "please select just one value"

let me know if you need help with the DAX for those measures.

[NiallMaths]

HI Ken

thanks for the steer into solving this, i think this won't be the method I'll use for this particular page in my report because of the users needs (I have deicded my initial problem is almost one that i have created for myself!), but will definitely use it for another part so is really useful, thank you

Niall