I have a dataset which is currently duplicated except in one column (Delivered Price) 1/2 of the dataset is displayed in USD and in the other 1/2 of the dataset that same column (Delivered Price) is displayed in CAD.
For users of my dashboard, I want to provide a option to view the underlying data in either CAD or USD, but not both at the same time. Currently, when I create a Slicer card type with two underlying options (CAD & USD), when a user first accesses the page, Null is selected on this card type (which causes all of the underlying information to be incorrectly duplicated). I would like to predefine the initial selection on this slicer for all users encountering this dashboard while still allowing users to toggle between these 2 (and perhaps more in the future) options. Also, I would like to eliminate having Null selected as an option in this fulter.
Tldr; I want a Slicer card where users can select CAD OR USD but not both and not nothing. This is an enhancement request and I have many use cases for this request.