Forum Discussion

pbrainard's avatar
pbrainard
Helper III
4 years ago
Solved

Multiple type counts in bar chart

I feel like this should be easy to achieve and maybe I'm trying too early in the AM. 🙂   I have about 10000 records of incident reports. Each incident report contains multiple incident types. I wa...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  pbrainard ,

    Currently, measures can be dragged to value or tooltips field, but can’t be dragged to legend or X-axis field in a bar chart.

    You can create a table, the content of the column is the name of the measure, and put this column into it to display.

    Here are the steps you can follow:

    1. Use Enter data to create a table.

    2. Create measure.

    Measure =
    SWITCH(
        TRUE(),
        MAX('Table2'[Group_measure])="MeasureA",[MeasureA],
        MAX('Table2'[Group_measure])="MeasureB",[MeasureB],
        MAX('Table2'[Group_measure])="MeasureC",[MeasureC],
        MAX('Table2'[Group_measure])="MeasureD",[MeasureD])

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly