Forum Discussion
Convert Table from Visualisation into Actual table?
Hi mlm0926
The table shown when selecting "Show as table" contains the same values you would see in a Table visual containing the same fields as the column chart. Behind the scenes, the DAX query for "Show as table" is essentially identical to the DAX query for a Table visual (without totals).
The only difference in appearance with "Show as table" is that the axis field values are shown as a comma-separated list for each aggregated value.
So you should be able to see essentially the same values if you make a copy of the column chart and convert it to a Table, without having to write any additional DAX.
Does this work for you?
Regards
Hi mlm0926
The table shown when selecting "Show as table" contains the same values you would see in a Table visual containing the same fields as the column chart. Behind the scenes, the DAX query for "Show as table" is essentially identical to the DAX query for a Table visual (without totals).
The only difference in appearance with "Show as table" is that the axis field values are shown as a comma-separated list for each aggregated value.
So you should be able to see essentially the same values if you make a copy of the column chart and convert it to a Table, without having to write any additional DAX.
Does this work for you?
Regards
Hi, I think I didn't explain properly. Your solution is correct as well but I'm wondering how I can create a table in the data based on the table from "Show as table" instead of the table visualisation?