Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
switch
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

1. I think you need to have a default value in case of measure slicer

2. You can rename title , I doubt you can rename column based on selection

 

also refer
measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak i have already a default mesure ans i return dynamicaly thetable n'aime with another measure. Thank toi for tour Reply.

     

    Anonymous Hello, in fact i would like a Dynamic column name shown in m'y Matrix visual depending on my selection.