How to a create a matrix to have a quarters, Months in the columns without drill through.

[Baks007]

Please refer to the below attachment for clarity.

[Anonymous]

Hi @Baks007,

You can use the date field on your matrix column field and switch it to hierarchy mode to keep the year, quarter, month, day levels and matrix will auto aggregate records based on current row and column groups.

Regards,

Xiaoxin Sheng

[Baks007]

@Anonymous Thanks for the response.Unfortunately The solution will not solve the requirement.

[Anonymous]

HI @Baks007,

What type of effects are you wanted? Did you mean to apply conditional formatting on matrix?
If that is the case, you can write a measure formula with ISFILTERED or ISINSCOPE function to check corresponds hierarchy levels and return different color code and use on conditional formatting.

Clever Hierarchy Handling in DAX - SQLBI

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Regards,

Xiaoxin Sheng