Forum Discussion
Create table from measure for visual
Hi communitiy,
I would need to create a new table for a visual. Should look like below. Value should result from several measures. How can I do this? Please help.
| Item | Value |
| External Sales | |
| Commercial Margin | |
| Indirect Cost | |
| Total Margin | |
| Department Cost | |
| R&D Cost | |
| Contribution Margin |
Thanks a lot!
Anonymous ,
you may try to create table by enter data feature to insert "Item" manually and then create calculated column for the value (include all of your measures in a calculation).
Thanks,
Arul
5 Replies
Anonymous , In a matrix use show on row
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Or use calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
amitchandak and Arul , thank you both for your quick replies. Unfortunately not the solution. I need this data table created. The measure used will be a waterfall chart based on the cretaed table.
I can get the doble done with dax, but only with the measures in columns, not in rows. Any ideas?
Thank you.
Anonymous ,
you may try to create table by enter data feature to insert "Item" manually and then create calculated column for the value (include all of your measures in a calculation).
Thanks,
Arul
Anonymous ,
Create a table and measure as like the below and use it in the visual,
Thanks,
Arul
