Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago
Solved

Passing Slicer value to column header name

Dear All,   Thank you in advance to all.    I have month column (Apr,may...mar) and Previous and Current Month Data columns.      I am trying to pass the slicer values to column header n...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi NadeemAhamed ,

    I think the first thing you need to know is that in Power BI Desktop's tables, you can't dynamically change the names of the columns you put in by means like DAX, you can only change its style and static name.

    So in your case, I think if you want to implement your needs, maybe you can try using Card Visual. The card is not in the form, but it can be returned in the form you want.

    Measure = "Current Month   " & SELECTEDVALUE(Sheet2[Month]) & "   Data"

     

     

     

    Best Regards

    Yilong Zhou

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

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

Anonymous 

 

Thank you soo much for your valuable time to read and reply my post.

 

actually i want to pass slicer month name in column header not in separate column.

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi NadeemAhamed ,

I think the first thing you need to know is that in Power BI Desktop's tables, you can't dynamically change the names of the columns you put in by means like DAX, you can only change its style and static name.

So in your case, I think if you want to implement your needs, maybe you can try using Card Visual. The card is not in the form, but it can be returned in the form you want.

Measure = "Current Month   " & SELECTEDVALUE(Sheet2[Month]) & "   Data"

 

 

 

Best Regards

Yilong Zhou

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