Forum Discussion
Use slicer to select which column to sum
Hi everyone,
I have a table with 30 columns, say C1...C30. And need to create a dashboard where a user can use slicer to pick which column to sum, and output it on a graph. E.g. when user selects C7 on slicer, then the graph plots a sum of column [C7].
I know one way to achieve this is to create 30 measures and use SWITCH() function. But is there a way to create just single measure and reference column name with a variable?
Thank you!
- Anonymous6 years ago
If you're able to use the query editor, select C1...C30 and click unpivot columns. That'll allow you to easily do it with one calculation.
You should also be able to use the UNION function in DAX, see below for an example
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
2 Replies
- AllisonKennedy
Community Champion
Anonymous
I agree with Anonymous
Without knowing more about what data is in columns 1 - 30, I also think this sounds like data that might be best unpivoted. - AnonymousNot applicable
If you're able to use the query editor, select C1...C30 and click unpivot columns. That'll allow you to easily do it with one calculation.
You should also be able to use the UNION function in DAX, see below for an example
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax