Dynamic change of Default Slicer selection

[Negi]

Hi All,

I am having data set like below mentioned table.

1) Matrix table view where I have added.

2) Implemented RLS where user have access based on Project. user may have access to all projects, partially project as well from below given table.

3) Created Parameter with 2 options "Local Currency" and "USD".

4) added company trigram filter as drop down in the view.

Problem statement :-

1) I want if any user select local curreny then company trigram autmatically change to single selection as it contains multiple currencies and in that case it will show wrong result if selction is not single.

2) If user select USD currency than user shuld have option to select all company trigram.

Please let me know if this is feasable if yes then please guide how to solve this issue ?  

Project	Date	Company Trigram	Currency Presentation	Cost USD	Currency Local	Cost Local
A	1-Jan-25	ABC	USD	105	INR	248
A	2-Jan-25	ABC	USD	246	CAD	621
B	3-Jan-25	DEF	USD	261	CAD	751
B	4-Jan-25	DEF	USD	254	USD	205
C	5-Jan-25	DEF	USD	189	USD	989
D	6-Jan-25	JKL	USD	155	AED	897
E	7-Jan-25	MNO	USD	478	AED	912
F	8-Jan-25	MNO	USD	205	AMD	164
F	9-Jan-25	PQR	USD	139	AMD	84
F	10-Jan-25	PQR	USD	307	CAD	375

[GrowthNatives · Accepted solution]

Hi @Negi , 
The main challenge being faced here is Power BI doesn’t directly allow conditional slicer behavior (single vs multi-select). But you can achieve the same effect using field parameters + DAX logic + a measure-based filter.

1. Keep the parameter as it is with values: Local Currency and USD.

2. Create a measure to detect invalid selection 

DAX 
Validate Company Selection =
VAR CurrencyMode = SELECTEDVALUE(Parameters[Currency Option])  -- Local Currency / USD
VAR SelectedCompanies = COUNTROWS(VALUES('Table'[Company Trigram]))
RETURN
IF(
    CurrencyMode = "Local Currency" && SelectedCompanies > 1,
    0,  -- Invalid selection
    1   -- Valid selection
)

3. Use this measure as visual level filter

On your main visuals, drag Validate Company Selection into the Filters pane & Set it to is 1.

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀  [Explore More] 

[GrowthNatives · Accepted solution]

Hi @Negi , 
The main challenge being faced here is Power BI doesn’t directly allow conditional slicer behavior (single vs multi-select). But you can achieve the same effect using field parameters + DAX logic + a measure-based filter.

1. Keep the parameter as it is with values: Local Currency and USD.

2. Create a measure to detect invalid selection 

DAX 
Validate Company Selection =
VAR CurrencyMode = SELECTEDVALUE(Parameters[Currency Option])  -- Local Currency / USD
VAR SelectedCompanies = COUNTROWS(VALUES('Table'[Company Trigram]))
RETURN
IF(
    CurrencyMode = "Local Currency" && SelectedCompanies > 1,
    0,  -- Invalid selection
    1   -- Valid selection
)

3. Use this measure as visual level filter

On your main visuals, drag Validate Company Selection into the Filters pane & Set it to is 1.

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀  [Explore More] 

[Negi]

Hi @GrowthNatives ,

I followed same step and measure but its after using it my workbook very flow unable to check as it contains 100 millions rows data.

[v-hjannapu · Accepted solution]

Hello @Negi,

Thanks for coming back with the details. The reason your report is becoming slow is because the measure we created is running on the full data table which has 100+ million rows. Every time the visual loads, it is scanning all those rows, so the performance goes down.

To handle this better, you don’t need to check on the main fact table. Instead, you can create a small separate table with only unique company trigrams and use that for the slicer. Then update the validation measure to use this smaller table. This way, the logic will still work (single selection for local currency, multi for USD) but it won’t touch the 100 million rows, so performance will improve.

This is a common approach in large models we try to shift slicers and validation logic to small lookup tables instead of the big fact table.

Hope this helps if you have any queries we are  happy to assist you further.
Regards,
Harshitha.

[v-hjannapu]

Hi @Negi,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

[Negi]

@v-hjannapu ,

I am trying to give and user option at starting to select USD/Location currency and based on that hiding the selection and redirecting to thr page view. will get back to you. 

[v-hjannapu]

Hi @Negi,

Thank you for the Update, please try to update it here once have tried it.


Regards,
Harshitha.

[v-hjannapu]

Hi @Negi,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.