Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I've got a simple table from which I want to get some values by accessing the table cells via row index and column index.
Unfortunately I've got no clue how I can achieve this...
I'm messing around in visual.ts with some TS code, but don't know what properties of the table dataview I have to use.
Is it even possible with the table dataview? Or do I really have to go the categorical way?
I don't need any aggregation (like sum), just the values...
Any help is welcome, thanks in advance!
Solved! Go to Solution.
Hi @Anonymous,
The details of the table data view mapping are supplied in the docs, including some output based on a sample dataset, but to break this down further:
You can access rows as table.rows[x] where x is a 0-based index, exactly like a JavaScript array.
Each row is an array of column values, so table.rows[x][y], where y is the index of the column you want the value for.
If you need to know which index represents which column, the column metadata is in the table.columns array. The index of each item corresponds with the index in the resulting rows array.
So, for example if your table.columns[0] entry represents 'Jahr' then table.rows[x].[0] will be the value of 'Jahr' for the given row entry.
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi @Anonymous,
The details of the table data view mapping are supplied in the docs, including some output based on a sample dataset, but to break this down further:
You can access rows as table.rows[x] where x is a 0-based index, exactly like a JavaScript array.
Each row is an array of column values, so table.rows[x][y], where y is the index of the column you want the value for.
If you need to know which index represents which column, the column metadata is in the table.columns array. The index of each item corresponds with the index in the resulting rows array.
So, for example if your table.columns[0] entry represents 'Jahr' then table.rows[x].[0] will be the value of 'Jahr' for the given row entry.
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
That helped. Thank you, dm-p!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
12 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
13 | |
4 | |
3 | |
3 | |
2 |