Determine the name of the field that the user clicks on

[StevenT]

Hi, In a table, is there a way to determine the field name of the data that user is clicking on?

[Shravan133]

1. Use a Measure to Capture Selected Value

If you want to determine the value a user is clicking on, create a DAX measure like this:

SelectedValue = SELECTEDVALUE(TableName[ColumnName], "No Value Selected")

This will return the value the user has selected in the table for that column.

2. Field Parameters to Dynamically Switch Fields

If you are working with multiple columns and want to dynamically capture the clicked column, use Field Parameters.

• Enable Field Parameters in Preview Features under File > Options > Preview Features.
• Create a Field Parameter by navigating to Modeling > New Parameter > Fields.
• Add the fields (columns) you want the user to select.
• Use the Field Parameter in your table or visual. Power BI will let you dynamically switch between columns, and you can use a slicer or measure to track which field is currently displayed.

3. Using Visual Interactions

If your goal is to perform an action based on what the user clicks on in the table:

• Enable interactions between visuals. When a user clicks on a value in the table, it filters or cross-highlights related visuals.
• You can use measures to react to the filtered state, like detecting the value the user selected.

4. Power BI Report Page Tooltips

To show additional context when the user hovers over a value, you can use a tooltip page. This will show the data the user is interacting with in a more detailed visual or table. However, it does not allow direct interaction with the field name itself.

[Anonymous]

Hi @StevenT ,

Are you talking about renaming fields? Below is the first way:

The second way is to go into the Power Query editor and modify the column name and apply it to Power BI Desktop.

Best Regards,

Stephen Tao

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

[Selva-Salimi]

Hi @StevenT 

your question is not that much clear for me. can you please share more details of what you expect.

you might need to use "selectedvalue" but not sure about your expectation.