Forum Discussion

SBC's avatar
SBC
Icon for Helper III rankHelper III
1 year ago
Solved

Dynamic Column Name in Table Visual Based on Date Slicer Selection

Hi, I am using a table visual in Power BI, and I want to implement a feature where the column header and data dynamically change based on the user’s selection from a date slicer. For example: If ...
  • sanalytics's avatar
    sanalytics
    1 year ago

    SBC 
    The easiest way to achive this kind of scenario is to create a separate measure and use selection of it..
    Below are steps :
    1) Rename the Sales week with space.
    2) Create a basic measure with selected value function.
    3) Drag the measure in card visual and format this...
    4) Group the card visual and Table visual
    Nothing fancy..
    Below screenshots

     

    There could be a way to achive this by adding a disconected table and write a measure top of it.. But it will add an unnecessary a table into your model.
    Let me know which way you want to like.
    Below is the attached pbix file.

     

    Hope it helps

     

    Regards

    sanalytics



     

sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
1 year ago

SBC 
The easiest way to achive this kind of scenario is to create a separate measure and use selection of it..
Below are steps :
1) Rename the Sales week with space.
2) Create a basic measure with selected value function.
3) Drag the measure in card visual and format this...
4) Group the card visual and Table visual
Nothing fancy..
Below screenshots

 

There could be a way to achive this by adding a disconected table and write a measure top of it.. But it will add an unnecessary a table into your model.
Let me know which way you want to like.
Below is the attached pbix file.

 

Hope it helps

 

Regards

sanalytics