Forum Discussion

pkoppurapu's avatar
pkoppurapu
Frequent Visitor
2 years ago

How to display selected value on table view in direct query mode?

Usage: I have table view that has multiple columns where users need to scroll right most to get complete information. I was to display the selected row in a text box or a card with all the column de...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi pkoppurapu ,

 

For direct query mode, you can't view table data in table view, you can only create calculated column to display the result in table visual or create calculated table with the help of addcolumn function. refer below:

 

Table =
ADDCOLUMNS (
    Table_1,
    "Result",
        Table_1[Col1] & "-" & Table_1[Col2] & "-" & Table_1[Col3]
)

Best Regards,
Adamk Kong

 

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

 

  • pkoppurapu's avatar
    pkoppurapu
    Frequent Visitor
    2 years ago

    Anonymous what if I want to display selected row of a table for a user? Like if a row is selected i want to display the whole row into a text box or a card visual. 
    calculated column provides the whole column values into a table.