Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Expression Resolution on a Table Column name

Hi PBI Community,

 

I have a requirement in which the user would make a Selection on the below Filter.  The Below is the Screenshot of the Filter.The User would make the Filter Selection Here

Once the user makes the selection. The Selected Value should appear under Current Week, The Previous Week to it should appear under Previous Week and the 13 Week Average should have the value of the last 13 Weeks previous to the Previous Week.

 

The Selected Filter option should appear instead of Current Week over Here

Eg: If i Select "2019w15" in the Filter, the Current Week Column will have the value "2019w15", The Previous Week Column will have the Value "2019w14" and the 13 Week Average will have the value "2019w11-2019w13".

 

P.S: I am able to bring out the Selection using a SELECTEDVALUE(). mapped it on a KPI and super-imposed the KPI over the Column name but when i Click on the Table the Original Column names appear.

Need Help
Show and Tell

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Thanks for your Suggestion. As I have mentioned above, the Expected Output is the below. For Instance, When i select the above filter as 2019w25, then the below should be the output on the Table Column Headers. Hope this Clarifies?

    This is the Expected Output with Previous 13 Week, PreviousWeek and Current Week respectively

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      7 years ago

      hi, Anonymous 

      Do you mean that you want the column name is dynamic? If so, According to my knowledge, it couldn't achieve in power bi for now. The column name couldn't be changed dynamically.

       

      Best Regards,

      Lin

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes that is Right. The Column name should be resolved dynamically. I know that the Column name would accept only string values but this is the Requirement. 

         

        I have also tried a workaround of Placing Three Different Measures (KPI Cards) super-imposed on the Table Column Headers make the Font Colors go (Green) so that the Column header Value is not shown but clicking on the Table is automatically bringing out the Original Column Headers.