Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic axis with dynamic grouping/hierarchy

Hi,

I am facing an issue while trying to build a chart with dynamic axis.

My data is in the following format (attached)

Dimension table:

Main Table

I want the report to be something like this: where I can select Chart context for the yaxis(multiple selection) and chart filter for regular slicing of data.

The chart should look something similar to:(the data is different...but same concept of metric and dimension) Here 3 metrics are used.

Is that possible?

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    Do you want the "Metric name" or the "dimension_name" show on the "yaxis" on the bar chart, then values from the second table show on the "value" as bars?

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Maggie Yes, I want to display the dimension names of the metrics that have been selected in the chart context. Suppose I select 3 metrics A,B,C (in this order) then the chart should show the values sliced by the chart filter with dimensions of C in the y axis which are grouped by dimensions of B, grouped by dimensions of A. Like the last image that I had attached.

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        Hi Anonymous 

        You could unpivot columns from "m0" to "m10" in main table, then relate the new column with dimension table based on the "metric id", 

        next add metric id into "row" bucket of a matrix.

         

        Best Regards

        Maggie