Add Extra Column in Export Data

[Anonymous]

Hi @all,

I want to add an extra column "Id" while exporting the Data from Bar chart visual.

I dont want the "Id" column to be displayed in the Bar chart visual. But when we export the bar chart visual, I want an extra column "Id" with respect to the "Name" column in the exported data sheet.

Can I know if we can do like this ?

[luapdoniv · Accepted solution]

Taking it to axis will serve the purpose. But the users can drill down on the hierarchy. You can try disabling the button specifically for this chart if that makes sense.

[luapdoniv]

Take the ID col to your tooltips in the chart and export

[Anonymous]

Hi @luapdoniv ,

Yea I have tried that but is there any way apart from toolpit. The toolpit shows on hover and displays first Id of Region, Territory.....

[Anonymous]

Hi @luapdoniv ,

Is there anyway I can hide only "Id" in the Tooltips ?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at Add report tooltips to enhance your visuals.

[luapdoniv · Accepted solution]

Taking it to axis will serve the purpose. But the users can drill down on the hierarchy. You can try disabling the button specifically for this chart if that makes sense.

[amitchandak]

Either you can export visual data or the Underlying data.

So I doubt you can export as visual data unless you add it to the chart.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Just add to axis and try, if that can work