Forum Discussion

tabi786's avatar
tabi786
Regular Visitor
7 years ago
Solved

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 ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

  • themistoklis's avatar
    themistoklis
    7 years ago

    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.

themistoklis's avatar
themistoklis
Community Champion
7 years ago

Hello tabi786

 

Please attached document. Maybe it will help you.

 

Also on the following image you can see how to select sum/count/max etc of a metric and also to choose the right graph from the objects.

 

tabi786's avatar
tabi786
Regular Visitor
7 years ago

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