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 ...
Need Help
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