Forum Discussion
advanced SWITCH usage
Hello, I am using switchs like this to dynamically change my columns in a table: -1 =
SWITCH(
[Selected Measure],
1,[Users_M1],
2,[Users_Q1],
3,[Users_Y1]
)
-2 =
SWITCH(
[Selected Mea...
If you're talking about raw tables in PBI, then they must be static out of necessity. You can't change them on the fly. Easy as that. If you're talking about visuals... then some of the functionalities might not be available, either. For instance, I don't think you can dynamically change the headers of a column in a matrix or table visual.
If you're talking about raw tables in PBI, then they must be static out of necessity. You can't change them on the fly. Easy as that. If you're talking about visuals... then some of the functionalities might not be available, either. For instance, I don't think you can dynamically change the headers of a column in a matrix or table visual.