topic Re: Issue with SELECTEDVALUE and SWITCH in DAX Commands and Tips

Issue with SELECTEDVALUE and SWITCH

Anonymous — Mon, 06 Nov 2023 02:02:59 GMT

Hello

I have a simple table (manual) in PBI that has 1 column and 3 values (Region, Segment, Market). With this table, I want to have a Slicer that will allow people to select 1 of the 3 values and use that value as a basis to select a column dynamically in the main Orders table. Here is the DAX code:

Dynamic Selection = VAR SelectedParameter = SELECTEDVALUE('Slicer'[Parameter]) RETURN SWITCH( TRUE(), SelectedParameter = "Region", 'Orders'[Region], SelectedParameter = "Market", 'Orders'[Market], SelectedParameter = "Segment", 'Orders'[Segment] )

There is no relationship between Orders and Slicer. I then have a chart with Dynamic Selection in the Legend to do the dynamic level of detail change. But, it resolves to blank no matter the selection I do.

Help with this greatly appreciated.

Re: Issue with SELECTEDVALUE and SWITCH

OwenAuger — Mon, 06 Nov 2023 02:24:49 GMT

Hi Anonymous

Calculated columns are static, and normally only "processed" on dataset refresh. They cannot respond to filters applied in a report.

Instead, you can use the field parameters feature to select a particular column (or measure) to be used in a visual.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

In this example, you would create a field parameter containing the three columns Region, Market, & Segment. Then place the field parameter column in the "Legend" field well.

Please post back if needed.

Regards

Re: Issue with SELECTEDVALUE and SWITCH

Anonymous — Mon, 06 Nov 2023 02:30:41 GMT

Haha I honestly spent ages trying to find the field parameter and didn't realise it was a server level setting to enable. I wondered why there was only numeric ones and that is why I had to go this route. Thanks heaps.