cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Predefined dimension selections-dimension

Hello Community,

I have a model with multiple dimensions and a lot of rows in both. Users are often looking at specific selections in both of them and it is often a hassle to select the correct ones in combination, switching between 'sets' and manually selecting all dimension values is often a cause for error.

consider this sample data:

escapethisscree_0-1671030108607.png

I would like to add another dimension containing pre-defined selections in my dimension tables. Essentially I would like to be able to place a slicer on a reportpage where the user can select a value which corresponds to a predefined amount of selectedvalues in dim1 and dim2.

 

How should I go about implementing this? Do I need a dimension filtering my two dimensions that "bridges" the two?

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

I'm not very clear about what you mean by "Predefined dimension selections-dimensions".

But I think you might need field parameters if you're trying to allow users to dynamically change the measure or dimension being analyzed in a report, 

Let report readers use field parameters to change visuals (preview) 

Create dynamic slicers using field parameters 

 

Best Regards,
Community Support Team _ Eason

 

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors