Hi @user365576 ,
@amitchandak ,good answer! That's one possible solution.
And you can try this way:
Create a new disconnected table by using DAX:
ColumnSelection = DATATABLE("ColumnName", STRING, {{"Column1"}, {"Column2"}, {"Column3"}})
which creates a table with a single column named 'ColumnName' and rows for each column you want to be selectable.
Then use DAX to create a new measure to switch columns dynamically:
DynamicMeasure =
VAR SelectedColumn = SELECTEDVALUE(ColumnSelection[ColumnName], "DefaultColumn")
RETURN
SWITCH(
SelectedColumn,
"Column1", SUM(Table[Column1]),
"Column2", SUM(Table[Column2]),
"Column3", SUM(Table[Column3]),
SUM(Table[DefaultColumn]) // Default case if no selection is made
)
Replace 'Table[Column1]', 'Table[Column2]', etc., with the actual column references from your data model.
Add the 'ColumnName' field from the disconnected table to a slicer visual on your report and add the 'DynamicMeasure' you created to the map visual. This measure will change based on the slicer selection.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
