topic Re: Switch headers in dynamic matrix built with calculation groups in Custom Visuals Development Discussion

Switch headers in dynamic matrix built with calculation groups

Anonymous — Wed, 28 Sep 2022 14:48:34 GMT

Hi guys,

I'm driving my self crazy with this one. I've used Tabular Editor to create a time intelligence Calculation group and I'm using a parameter to define my measures so that users can build their own dynamic matrix tables by selecting the things they want:

So this means in my values I have the measures and in the column of the matrix I have the time intelligence calculation group (Formula):

The problem I'm facing is that the business user wants to have the headers of the matrix switched from this current set up:

To this:

Meaning that the time and measures should switch places but it's proving impossible with this dynamic matrix table since I have to have the time intelligence formula in the columns and the measures in the values. Any ideas on some DAX that ,can maybe overcome this,or something that can be done in Tabular Editor.

Re: Switch headers in dynamic matrix built with calculation groups

lbendlin — Fri, 30 Sep 2022 22:07:14 GMT

You may want to consider using field parameters instead of calculation groups.

As for the crazy column hierarchy - that requires a disconnected table and a crossjoin to fakely convert the measures into columns.

Re: Switch headers in dynamic matrix built with calculation groups

Anonymous — Mon, 03 Oct 2022 07:28:36 GMT

Hi Ibendlin,

My mistake in the wording, the measure (Sales figures and Market Share) are done via paramneters and the time intelligence via Calculation groups, to save time and to not have 130 combinations of measures bulk up the file size. Do you think that with this combination of 1 parameter and one calculation group it is still possible to have the disconected table and crossjoin option and if so do you have some article on this subject that I can read on and try implementing the suggested sollution?

Thank you again in advance!

Re: Switch headers in dynamic matrix built with calculation groups

lbendlin — Tue, 04 Oct 2022 01:09:14 GMT

No, i don't think that can be done in a sustainable fashion. Push back on the user requirement. Your implementation is already complex enough.