Forum Discussion

2Late's avatar
2Late
New Member
4 years ago

Dynamic Column Name (measure name)

Hi,

I have data as in screen.

 

My case was to allow users to select what they wish to compare (eg Now to Budgert 1 or Budget 1 to Budget 2). I did it this way - i have create measure

Source1 = SELECTEDVALUE(SelectSource_1[Source])
and second that is related
Value_S1 = CALCULATE([Value], FILTER(dicSource, dicSource[Source]=[Source1]))
 
Exactly same for Source2. Table work fine, no issue with data.
 
But users ask my to change column name as they are "Value_S1" and "Value_S2" (becouse that is measure name).
They wish to see "NOW", or "Budget_1" - base on selected in Source1 and Source2 value.
 
How to do that ?
Need Help

4 Replies

    • 2Late's avatar
      2Late
      New Member
      4 years ago

      amitchandakThaks for aswer, i afrait that its not possible. I was trying to hide Measure Name below Label (where i can get correct name). But users loose posibility to sort column by clicking in them. No clue how to give them correct names 😞

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi 2Late 

    Thanks for reaching out to us.

    Actually, it's not supported to rename your measure dynamically according to another value you selected.

    My suggestion is to add a prompt card next to it, showing what the user currently selects, you can use selectedvalue() in card visual.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi 2Late 

    Can we close this thread now if there is no other question? It would be nice if you can accpet answer helpful as the solution. Thanks 🙂

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly