Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Elnur
New Member

reverse-engineer a data table - amend the data source by adjusting visuals on the chart

Is there a way to change the data in the source from controls on the chart? For example, drag the top of one of bars in the chart, and the data table is adjusted accordingly? Or move a sector in pie-chart, and the underlying data is adjusted accordingly... in other words, reverse engineer the data table based on the desired look of the chart.

 

The practical application for us, is to allow users to allocate their time in the time-sheet based on relative size of the bars for the specific projects. Probably asking for too much, but thought it is worth asking.

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee


@Elnur wrote:

Is there a way to change the data in the source from controls on the chart? For example, drag the top of one of bars in the chart, and the data table is adjusted accordingly? Or move a sector in pie-chart, and the underlying data is adjusted accordingly... in other words, reverse engineer the data table based on the desired look of the chart.

 

The practical application for us, is to allow users to allocate their time in the time-sheet based on relative size of the bars for the specific projects. Probably asking for too much, but thought it is worth asking.


@Elnur

It is not possible. The charts in reports are based on the underlying data tables, not reverse-engineer unfortunately. You can only model data via DAX or PowerQuery.

View solution in original post

1 REPLY 1
Eric_Zhang
Employee
Employee


@Elnur wrote:

Is there a way to change the data in the source from controls on the chart? For example, drag the top of one of bars in the chart, and the data table is adjusted accordingly? Or move a sector in pie-chart, and the underlying data is adjusted accordingly... in other words, reverse engineer the data table based on the desired look of the chart.

 

The practical application for us, is to allow users to allocate their time in the time-sheet based on relative size of the bars for the specific projects. Probably asking for too much, but thought it is worth asking.


@Elnur

It is not possible. The charts in reports are based on the underlying data tables, not reverse-engineer unfortunately. You can only model data via DAX or PowerQuery.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.