Forum Discussion
Issue with SELECTEDVALUE and SWITCH
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.
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
2 Replies
- OwenAuger
Super User
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