Forum Discussion
Show table columns as Visual Bar graph
Hi,
I have this data table with five columns.
I want to generate a visual like this.
It should show amount (not Count) of DPC, Hirtshal, ATC and TC i bare graph. Can anyone help?
Regards.
Aftab Ahmad
Hi tabi786,
Measures could not be added as columns in visual. You can try to create new calcualted columns to work on it.
Regards,
Frank
Hello tabi786,
As v-frfei-msft mentioned, you cannot do this using measures.
Another alternative is to flip the table.
So instead of having the departments as rows and the measures as columns you must have the measures as rows and the departments as columns.
To create this table you have to use Power Query. I dont think you can do it using DAX formulas.
4 Replies
Hi tabi786,
Measures could not be added as columns in visual. You can try to create new calcualted columns to work on it.
Regards,
Frank
Hello tabi786,
As v-frfei-msft mentioned, you cannot do this using measures.
Another alternative is to flip the table.
So instead of having the departments as rows and the measures as columns you must have the measures as rows and the departments as columns.
To create this table you have to use Power Query. I dont think you can do it using DAX formulas.
Hi themistoklis
Thank you for your answer. I have also attached my Document. I am creating this visual on the last page of the report. I want DTC, ATC, Hirtshall on the X axis not RDdept.Report
Aftab Ahmad
