Forum Discussion

GGarnize's avatar
GGarnize
New Member
3 years ago
Solved

Change column as title in tableEx Embeeded

I Want to change in my 'tableEx', how header of column is shown.
I've been mounting the code in the 'embedded playground', and I can't do it there.

 

try {
        await authoringPage.setActive();
        const customLayout = {
            x: 0,
            y: 0,
            height: 300,
            width: 700,
            displayState: {
                mode: models.VisualContainerDisplayMode.Visible,
            },
        }
        const response = await authoringPage.createVisual('tableEx', customLayout);
        window.lastCreatedVisual = response.visual;

        // Defining data fields
        const regionColumn = { column: 'Region', table: 'Geo', schema: 'http://powerbi.com/product/schema#column' };

        // Adding visual data fields
        lastCreatedVisual.addDataField('Values', regionColumn);
    }

 

I Want "Region" in my table, appear "TEST" for example... I Tried "

const regionColumn = { column: 'Region AS TEST', table: 'Geo', schema: 'http://powerbi.com/product/schema#column' };
But some error occured.
  • Anonymous's avatar
    Anonymous
    3 years ago

    Try put this line: 

     

    await lastCreatedVisual.setDataFieldDisplayName('Values', 0, 'TEST'); 

     

    In "setDataFieldDisplayName",
    first parameter is DataRole that you want change display name;
    second parameter is position, if you have 3 "Values" for example, you need pass who you want to change;
    and the third parameter, is what you want display.

    This line probably resolve your problem

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Try put this line: 

     

    await lastCreatedVisual.setDataFieldDisplayName('Values', 0, 'TEST'); 

     

    In "setDataFieldDisplayName",
    first parameter is DataRole that you want change display name;
    second parameter is position, if you have 3 "Values" for example, you need pass who you want to change;
    and the third parameter, is what you want display.

    This line probably resolve your problem