Forum Discussion
Issue with SELECTEDVALUE and SWITCH
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
Super UserHi 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
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.