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,

 

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.