Dynamic axis with dynamic grouping/hierarchy

[Anonymous]

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?

[v-juanli-msft]

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]

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]

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