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.
In the example above, month Apr, May and Jun would be selected in a slicer. If other months say Jul and August were selected too then it should have shown those months too.
A matrix doesn't help as all dimensions have to be displayed before the measures itself so the measures end up outside the viewable area, plus a mtrix doesn't allow sorting on a say an individual month either.
Is there a trick available that can allow a dynamic set of columns to appear in a table based on a month selection and ideally without having to create individual measures for each month and a introduce a disconnected slicer etc?
2 Replies
vickyd seems like you are looking for a Hybrid display with Matrix Column and measure . refer if these can help
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc- 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.
