Issue with SELECTEDVALUE and SWITCH

[ryan_aicd2]

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. 

[OwenAuger · Accepted solution]

Hi @ryan_aicd2 

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

[ryan_aicd2]

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.