Matrix repeating the entire set of column headers per measure

[krishna_1811]

Hello, I require a matrix visual. I have four measures. I have put geo and multi-area on row headers and fiscal year and fiscal quarter on column headers, but I want one set of fiscal year and quarter for one measure, then repeat this entire column part for another measure and continue with horizontal scroller. 

By default, if I put all four measures, then all four measures are shown under one quarter and then the next quarter, like this.

Is this possible?

Does Power BI’s matrix support repeating the entire set of column headers per measure ? Any workaround with the disconnected table or something else

[v-sgandrathi · Accepted solution]

Hi @krishna_1811,

As of now, Power BI’s matrix visual does not natively support repeating the entire set of column headers (such as Fiscal Year and Fiscal Quarter) for each individual measure. By default, when multiple measures are added to a matrix, Power BI places all the measures under each combination of the column headers. A commonly used workaround is to create a disconnected table that acts as a "measure selector" and use a dynamic SWITCH measure to display values based on the selected measure. This setup allows you to place the Measure Selector at the top of the column hierarchy, followed by Fiscal Year and Quarter, effectively mimicking the desired layout where each measure has its own set of time-based headers. This method also enables horizontal scrolling across measures while maintaining a clean and organized view.

Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.

Thank you.

[krishna_1811]

Almost the same, I have applied by creating another disconnected table using the datatable DAX and using ISINSCOPE DAX to active hierarchy and measure

[v-sgandrathi]

Hi @krishna_1811,

Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

[lbendlin]

Values...Show on Rows