Forum Discussion
Dynamic (month) columns in a Table Visual
I have a requirement where I need to show a bunch of employees with a few dimensions/attributes, followed by a month-wise trend of a couple of metrics, followed by a few more dimensions. ...
I can't think of an easy way to get what you want exactly. Could you settle for all the dimensions on the left, then the month values for the various metrics on the right? You would need to create a table with a few columns: [Metric], [Month], [Metric Month] and [Value] that summarizes all the data for all metrics and months you want to report on, then connect that to your slicer for month and metric and use a matrix visual.